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

"The only role models you need are bad ones, Good ones just get in the way of you becoming yourself " - Jane Rule

Related commands:

ALTER APPLICATION ROLE
DROP APPLICATION ROLE

Equivalent Oracle command:

ALTER SESSION SET CURRENT SCHEMA