Oracle Database 口令文件与参数文件管理
创建口令文件$ orapwd file=/u01/app/oracle/product/11.2.0/db_1/dbs/orapwking password=oracle entries=5 force=y
$ sqlplus / as sysdba
SQL> show parameter remote_login_passwordfile
NAME TYPE VALUE
------------------------------------ --------------------------------- ------------------------------
remote_login_passwordfile string EXCLUSIVE
SQL> grant sysdba to tpcc;
SQL> select * from v$pwfile_users;
USERNAME SYSDBA SYSOPER SYSASM
-------------------- --------------- --------------- ---------------
SYS TRUE TRUE FALSE
TPCC TRUE FALSE FALSE
SQL> revoke sysdba from tpcc;
SQL> select * from v$pwfile_users;
USERNAME SYSDBA SYSOPER SYSASM
-------------------- --------------- --------------- ---------------
SYS TRUE TRUE FALSE
页:
[1]