CREATE APPLICATION ROLE (Transact-SQL)
Adds an application role to the current database.
CREATE APPLICATION ROLE application_role_name WITH PASSWORD = 'password' [ , DEFAULT_SCHEMA = schema_name ]
Specifies the name of the application role. This name must not already be used to refer to any principal in the database.
Specifies the password that database users will use to activate the application role. You should always use strong passwords. password must meet the Windows password policy requirements of the computer that is running the instance of SQL Server.
Specifies the first schema that will be searched by the server when it resolves the names of objects for this role. If DEFAULT_SCHEMA is left undefined, the application role will use DBO as its default schema. schema_name can be a schema that does not exist in the database.
Application roles are visible in the sys.database_principals catalog view.
For information about how to use application roles, see Application Roles.
Requires ALTER ANY APPLICATION ROLE permission on the database.
The following example creates an application role called
weekly_receipts that has the password
Sales as its default schema.
CREATE APPLICATION ROLE weekly_receipts WITH PASSWORD = '987G^bv876sPY)Y5m23' , DEFAULT_SCHEMA = Sales; GO