查看用户拥有的权限

[oracle@fenet bdump]$ sqlplus /nolog

SQL*Plus: Release 9.2.0.4.0 - Production on Thu Jun 21 15:13:09 2007

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL> conn /as sysdba
Connected.
SQL> grant create directory to masamk;
grant create directory to masamk
      *
ERROR at line 1:
ORA-00990: missing or invalid privilege

SQL> !oerr ora 990
00990, 00000, "missing or invalid privilege"
// *Cause:
// *Action:

SQL>

--查看当前用户被授予的权限
select granted_role from user_role_privs
union
select privilege from user_sys_privs

--查看拥有sys权限的用户
select * from V$PWFILE_USERS

--查看系统授予各个用户的权限
select * from dba_sys_privs
--查看系统授予用户某些对象的权限情况，比如授予某表的select权限给某用户
select * from dba_tab_privs;
--查看系统授予所有用户的权限情况
select * from dba_role_privs;

SQL> select privilege from dba_sys_privs where privilege like '%DIRECTORY%';

PRIVILEGE
----------------------------------------
DROP ANY DIRECTORY
CREATE ANY DIRECTORY
DROP ANY DIRECTORY
CREATE ANY DIRECTORY
DROP ANY DIRECTORY
CREATE ANY DIRECTORY
DROP ANY DIRECTORY
CREATE ANY DIRECTORY
DROP ANY DIRECTORY
CREATE ANY DIRECTORY
DROP ANY DIRECTORY

PRIVILEGE
----------------------------------------
CREATE ANY DIRECTORY

12 rows selected.

SQL> grant create any directory to masamk;

Grant succeeded.

SQL>