sys.sp_helprolemember

Description

Returns information about the direct members of a role in the current database.

Syntax

sp_helprolemember [ [ @rolename = ]
N
'rolename'
]
[ ; ]

Examples

Example 1

sp_helprotect

Example 2

sp_helprolemember

Example 3

EXECUTE sp_helprole;

Example 4

MemberName

Example 5

sp_helprolemember

Example 6

User1

Example 7

Role1

Example 8

Role1

Example 9

Role2

Example 10

EXECUTE sp_helprolemember
'Role2';

(. and 8 more examples)