口令文件用于验证特权用户,特权用户是指具有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