Oracle Password File 理解

重新理解[@more@]

口令檔案用於驗證特權使用者,特權使用者是指具有SYSDBA和SYSOPER 許可權的特殊資料庫使用者,這些使用者可以啟動例程關閉例程,建立資料庫,執行備份和恢復等操作.實驗記錄如下:

SYS on 15-MAY-07 at testdb>select * from v$pwfile_users;
SYS TRUE TRUE

SYS on 15-MAY-07 at testdb>create user test identified by test;

User created.

SYS on 15-MAY-07 at testdb>grant sysoper to test;

Grant succeeded.

SYS on 15-MAY-07 at testdb>select * from v$pwfile_users;
SYS TRUE TRUE
TEST FALSE TRUE

SYS on 15-MAY-07 at testdb>revoke sysoper from test;

Revoke succeeded.

SYS on 15-MAY-07 at testdb>select * from v$pwfile_users;
SYS TRUE TRUE

SYS on 15-MAY-07 at testdb>grant sysdba to test;

Grant succeeded.

SYS on 15-MAY-07 at testdb>select * from v$pwfile_users;
SYS TRUE TRUE
TEST TRUE FALSE

SYS on 15-MAY-07 at testdb>grant sysoper to test;

Grant succeeded.

SYS on 15-MAY-07 at testdb>select * from v$pwfile_users;
SYS TRUE TRUE
TEST TRUE TRUE