user_sys_privs 表存储了当前登录用户的priviledges信息。

C:\Documents and Settings\Administrator>sqlplus icmadmin/fvt6eip@icmnlsdb

SQL*Plus: Release 10.2.0.3.0 - Production on Fri Jun 27 05:26:11 2008

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> select * from user_sys_privs;

USERNAME                       PRIVILEGE                                ADM
—————————— —————————————- —
ICMADMIN                       CREATE SESSION                           NO
ICMADMIN                       CREATE ANY DIRECTORY                     NO
ICMADMIN                       CREATE TRIGGER                           NO
ICMADMIN                       CREATE TYPE                              NO

…….