Change the name, password, or default schema of an application role.
Syntax ALTER APPLICATION ROLE application_role_name WITH <set_item> [ ,...n ] <set_item> ::= NAME = new_application_role_name | PASSWORD = 'password' | DEFAULT_SCHEMA = schema_name Key: NAME Unique name of the application role.
PASSWORD The password for the application role. Password complexity will be checked.
DEFAULT_SCHEMA The first schema to be used to resolve object names. can be a schema that does not exist in the database.
ALTER APPLICATION ROLE Vincentio WITH PASSWORD = 'some897long_random64string'; GO ALTER APPLICATION ROLE Vincentio WITH NAME = Petruchio; GO
"People think modelling's mindless, that you just stand there and pose, but it doesn't have to be that way. I like to have a lot of input. I know how to wear a dress, whether it should be shot with me standing up or sitting" ~ Linda Evangelista
CREATE APPLICATION ROLE
DROP APPLICATION ROLE
Equivalent Oracle command: ALTER SESSION SET CURRENT SCHEMA