Add an application role to the current database.
Syntax CREATE APPLICATION ROLE application_role_name WITH PASSWORD = 'password' [ , DEFAULT_SCHEMA = schema_name ]
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.
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
ALTER APPLICATION ROLE
DROP APPLICATION ROLE
Equivalent Oracle command:
ALTER SESSION SET CURRENT SCHEMA