четвер, 30 травня 2013 р.

Oracle database tips&tricks

Here I am going to collect useful queries for Oracle database.

If you use many database users and need to check which of them are locked:
select username, ACCOUNT_STATUS from dba_users where username in ('DB_USER1', 'DB_USER2', 'DB_USER3', ....);
User with EXPIRED or LOCKED status can reactivated back to OPEN status by:
alter user DB_USER1 account unlock;
To prevent account expiration in future - you can set unlimited password time frame for all users with default profile:
alter profile default limit password_life_time_unlimited;

Немає коментарів:

Дописати коментар