ALTER APPLICATION ROLE

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. 

Examples

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

Related:

CREATE APPLICATION ROLE
DROP APPLICATION ROLE
Password generator
Equivalent Oracle command: ALTER SESSION SET CURRENT SCHEMA