Any user can run the ALTER AUTHORIZATION...SET PASSWORD command to change their own password. Any user can also run the ALTER AUTHORIZATION...SET DEFAULT SCHEMA to change their own schema, as long as the user owns or has OWNER privileges on the default schema.

If you have DBA privileges, you can run the ALTER AUTHORIZATION command to change another user's default schema or password.

To run an ALTER AUTHORIZATION command, form a statement with the user name and the desired password or default schema. The specified user name must exist in the database. The password you enter can be up to 128 characters long, is case-sensitive, and must be surrounded by single quotes.

If you specify a schema in the ALTER AUTHORIZATION...SET DEFAULT SCHEMA clause that does not exist in the database, Data Vault creates the schema and assigns the user OWNER privileges with the GRANT option on the schema. If the default schema you specify exists in the database but the user does not own it, Data Vault assigns the user OWNER privileges without the GRANT option on the schema.

You can run one ALTER AUTHORIZATION command at a time. To change both the password and default schema for a non-DBA user, run the ALTER AUTHORIZATION...SET PASSWORD and ALTER AUTHORIZATION...SET DEFAULT SCHEMA commands separately.

The following statement changes the default schema to

vip

for

user1

:

The following statement changes the password to

pass123

for

user1

:

ALTER AUTHORIZATION user1 SET PASSWORD 'pass123';