 Create Application Role
CREATE APPLICATION ROLE
Add an application role to the current database.
Syntax
CREATE APPLICATION ROLE application_role_name
WITH PASSWORD = 'password' [ , DEFAULT_SCHEMA = schema_name ]
Key:
password: The password that users will use to activate the application role.
schema_name: The first schema that will be searched by the server when it resolves the names of objects for this role. If undefined, the application role will use DBO as its default schema. schema_name can be a schema that does not exist in the database.
Example
CREATE APPLICATION ROLE Vincentio
WITH PASSWORD = '987Gbv876sPYY5m23'
, DEFAULT_SCHEMA = Shrew;
GO |