oracle用户授权sysdba
- 查看具有sysdba权限的用户
SQL> col username for a10
SQL> select * from v$pwfile_users;
USERNAME SYSDBA SYSOPER SYSASM
---------- ---------- ---------- ----------
SYS TRUE TRUE FALSE
SQL>
- 普通用户授权sysdba权限
SQL> col username for a10
SQL> select * from v$pwfile_users;
USERNAME SYSDBA SYSOPER SYSASM
---------- ---------- ---------- ----------
SYS TRUE TRUE FALSE
SQL>
- 移除用户sysdba权限
SQL> revoke sysdba from scott;
撤销成功。
SQL> select * from v$pwfile_users;
USERNAME SYSDBA SYSOPER SYSASM
---------- ---------- ---------- ----------
SYS TRUE TRUE FALSE
SQL>