AppRole Property

SQL-DMO

SQL-DMO

AppRole Property

The AppRole property exposes the security context for a database role.

Applies To
DatabaseRole Object
Syntax

object.AppRole [= value]

Parts

object

Expression that evaluates to an object in the Applies To list

value

TRUE or FALSE

Data Type

Boolean

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetAppRole(LPBOOL pRetVal);

HRESULT SetAppRole(BOOL NewValue);

Remarks

Microsoft® SQL Server™ supports database roles defined specifically for use by client applications. For more information about database roles used by client applications, see Establishing Application Security and Application Roles.

A password is required for any application role. When AppRole is TRUE, a value must be supplied for the DatabaseRole object Password property.