Query user_tab_privs : user_tab_privs « System Tables Views « Oracle PL / SQL






Query user_tab_privs

 
SQL>
SQL>
SQL> desc user_tab_privs;
 Name                   Null?    Type
-----------------------------------------------------------------------------------------
 GRANTEE               NOT NULL  VARCHAR2(30)
 OWNER                 NOT NULL  VARCHAR2(30)
 TABLE_NAME            NOT NULL  VARCHAR2(30)
 GRANTOR               NOT NULL  VARCHAR2(30)
 PRIVILEGE             NOT NULL  VARCHAR2(40)
 GRANTABLE                       VARCHAR2(3)
 HIERARCHY                       VARCHAR2(3)

SQL> select * from user_tab_privs where rownum < 50;

GRANTEE                        OWNER                          TABLE_NAME                     GRANTOR                PRIVILEGE                                GRA HIE
------------------------------ ------------------------------ ------------------------------ ------------------------------ ---------------------------------------- --- ---
CTXSYS                         SYS                            ICOL$                          SYS                    SELECT                                   YES NO
CTXSYS                         SYS                            CON$                           SYS                    SELECT                                   YES NO
CTXSYS                         SYS                            IND$                           SYS                    SELECT                                   YES NO
CTXSYS                         SYS                            COL$                           SYS                    SELECT                                   YES NO
CTXSYS                         SYS                            TS$                            SYS                    SELECT                                   YES NO
CTXSYS                         SYS                            CCOL$                          SYS                    SELECT                                   YES NO
FLOWS_020100                   SYS                            USER$                          SYS                    SELECT                                   YES NO
XDB                            SYS                            USER$                          SYS                    SELECT                                   NO  NO
CTXSYS                         SYS                            USER$                          SYS                    SELECT                                   YES NO
FLOWS_020100                   SYS                            OBJ$                           SYS                    SELECT                                   NO  NO
CTXSYS                         SYS                            OBJ$                           SYS                    SELECT                                   YES NO

GRANTEE                        OWNER                          TABLE_NAME                     GRANTOR                PRIVILEGE                                GRA HIE
------------------------------ ------------------------------ ------------------------------ ------------------------------ ---------------------------------------- --- ---
CTXSYS                         SYS                            TAB$                           SYS                    SELECT                                   YES NO
CTXSYS                         SYS                            CDEF$                          SYS                    SELECT                                   YES NO
CTXSYS                         SYS                            SYN$                           SYS                    SELECT                                   YES NO
CTXSYS                         SYS                            VIEW$                          SYS                    SELECT                                   YES NO
CTXSYS                         SYS                            ARGUMENT$                      SYS                    SELECT                                   YES NO
CTXSYS                         SYS                            SYSAUTH$                       SYS                    SELECT                                   YES NO
EXP_FULL_DATABASE              SYS                            INCEXP                         SYS                    UPDATE                                   NO  NO
EXP_FULL_DATABASE              SYS                            INCEXP                         SYS                    INSERT                                   NO  NO
EXP_FULL_DATABASE              SYS                            INCEXP                         SYS                    DELETE                                   NO  NO
SYSTEM                         SYS                            INCEXP                         SYS                    FLASHBACK                                NO  NO
SYSTEM                         SYS                            INCEXP                         SYS                    DEBUG                                    NO  NO

GRANTEE                        OWNER                          TABLE_NAME                     GRANTOR                PRIVILEGE                                GRA HIE
------------------------------ ------------------------------ ------------------------------ ------------------------------ ---------------------------------------- --- ---
SYSTEM                         SYS                            INCEXP                         SYS                    QUERY REWRITE                            NO  NO
SYSTEM                         SYS                            INCEXP                         SYS                    ON COMMIT REFRESH                        NO  NO
SYSTEM                         SYS                            INCEXP                         SYS                    REFERENCES                               NO  NO
SYSTEM                         SYS                            INCEXP                         SYS                    UPDATE                                   NO  NO
SYSTEM                         SYS                            INCEXP                         SYS                    SELECT                                   NO  NO
SYSTEM                         SYS                            INCEXP                         SYS                    INSERT                                   NO  NO
SYSTEM                         SYS                            INCEXP                         SYS                    INDEX                                    NO  NO
SYSTEM                         SYS                            INCEXP                         SYS                    DELETE                                   NO  NO
SYSTEM                         SYS                            INCEXP                         SYS                    ALTER                                    NO  NO
EXP_FULL_DATABASE              SYS                            INCVID                         SYS                    UPDATE                                   NO  NO
EXP_FULL_DATABASE              SYS                            INCVID                         SYS                    INSERT                                   NO  NO

GRANTEE                        OWNER                          TABLE_NAME                     GRANTOR                PRIVILEGE                                GRA HIE
------------------------------ ------------------------------ ------------------------------ ------------------------------ ---------------------------------------- --- ---
EXP_FULL_DATABASE              SYS                            INCVID                         SYS                    DELETE                                   NO  NO
SYSTEM                         SYS                            INCVID                         SYS                    FLASHBACK                                NO  NO
SYSTEM                         SYS                            INCVID                         SYS                    DEBUG                                    NO  NO
SYSTEM                         SYS                            INCVID                         SYS                    QUERY REWRITE                            NO  NO
SYSTEM                         SYS                            INCVID                         SYS                    ON COMMIT REFRESH                        NO  NO
SYSTEM                         SYS                            INCVID                         SYS                    REFERENCES                               NO  NO
SYSTEM                         SYS                            INCVID                         SYS                    UPDATE                                   NO  NO
SYSTEM                         SYS                            INCVID                         SYS                    SELECT                                   NO  NO
SYSTEM                         SYS                            INCVID                         SYS                    INSERT                                   NO  NO
SYSTEM                         SYS                            INCVID                         SYS                    INDEX                                    NO  NO
SYSTEM                         SYS                            INCVID                         SYS                    DELETE                                   NO  NO

GRANTEE                        OWNER                          TABLE_NAME                     GRANTOR                PRIVILEGE                                GRA HIE
------------------------------ ------------------------------ ------------------------------ ------------------------------ ---------------------------------------- --- ---
SYSTEM                         SYS                            INCVID                         SYS                    ALTER                                    NO  NO
EXP_FULL_DATABASE              SYS                            INCFIL                         SYS                    UPDATE                                   NO  NO
EXP_FULL_DATABASE              SYS                            INCFIL                         SYS                    INSERT                                   NO  NO
EXP_FULL_DATABASE              SYS                            INCFIL                         SYS                    DELETE                                   NO  NO
SYSTEM                         SYS                            INCFIL                         SYS                    FLASHBACK                                NO  NO

49 rows selected.

SQL>

 








Related examples in the same category