sys.sp_setapprole

Description

Activates the permissions associated with an application role in the current database.

Syntax

sp_setapprole
[ @rolename = ]
N
'rolename'
, [ @password = ]
N
'password'
[ , [ @encrypt = ]
'encrypt'
]
[ , [ @f
C reate
C ookie = ] f
C reate
C ookie ]
[ , [ @cookie = ] cookie
OUTPUT
]
[ ; ]