Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

Object Grants to Users

SQL> SQL> SELECT b.owner || '.' || b.table_name obj,   2         b.privilege what_granted, b.grantable,   3         a.username   4  FROM   sys.dba_users a, sys.dba_tab_privs b   5  WHERE  a.username = b.grantee   6  and    rownum < 50   7  ORDER BY 1,2,3; OBJ ------------------------------------------------------------- WHAT_GRANTED                             GRA USERNAME ---------------------------------------- --- ------------------------------ SYS.ARGUMENT$ SELECT                                   YES CTXSYS SYS.CCOL$ SELECT                                   YES CTXSYS SYS.CDEF$ SELECT                                   YES CTXSYS OBJ ------------------------------------------------------------- WHAT_GRANTED                             GRA USERNAME ---------------------------------------- --- ------------------------------ SYS.COL$ SELECT                                   YES CTXSYS SYS.CON$ SELECT                                   YES CTXSYS SYS.ICOL$ SELECT                                   YES CTXSYS OBJ ------------------------------------------------------------- WHAT_GRANTED                             GRA USERNAME ---------------------------------------- --- ------------------------------ SYS.INCEXP ALTER                                    NO  SYSTEM SYS.INCEXP DEBUG                                    NO  SYSTEM SYS.INCEXP DELETE                                   NO  SYSTEM OBJ ------------------------------------------------------------- WHAT_GRANTED                             GRA USERNAME ---------------------------------------- --- ------------------------------ SYS.INCEXP FLASHBACK                                NO  SYSTEM SYS.INCEXP INDEX                                    NO  SYSTEM SYS.INCEXP INSERT                                   NO  SYSTEM OBJ ------------------------------------------------------------- WHAT_GRANTED                             GRA USERNAME ---------------------------------------- --- ------------------------------ SYS.INCEXP ON COMMIT REFRESH                        NO  SYSTEM SYS.INCEXP QUERY REWRITE                            NO  SYSTEM SYS.INCEXP REFERENCES                               NO  SYSTEM OBJ ------------------------------------------------------------- WHAT_GRANTED                             GRA USERNAME ---------------------------------------- --- ------------------------------ SYS.INCEXP SELECT                                   NO  SYSTEM SYS.INCEXP UPDATE                                   NO  SYSTEM SYS.INCFIL DEBUG                                    NO  SYSTEM OBJ ------------------------------------------------------------- WHAT_GRANTED                             GRA USERNAME ---------------------------------------- --- ------------------------------ SYS.INCFIL DELETE                                   NO  SYSTEM SYS.INCFIL FLASHBACK                                NO  SYSTEM SYS.INCFIL INDEX                                    NO  SYSTEM OBJ ------------------------------------------------------------- WHAT_GRANTED                             GRA USERNAME ---------------------------------------- --- ------------------------------ SYS.INCFIL INSERT                                   NO  SYSTEM SYS.INCFIL ON COMMIT REFRESH                        NO  SYSTEM SYS.INCFIL QUERY REWRITE                            NO  SYSTEM OBJ ------------------------------------------------------------- WHAT_GRANTED                             GRA USERNAME ---------------------------------------- --- ------------------------------ SYS.INCFIL REFERENCES                               NO  SYSTEM SYS.INCFIL SELECT                                   NO  SYSTEM SYS.INCFIL UPDATE                                   NO  SYSTEM OBJ ------------------------------------------------------------- WHAT_GRANTED                             GRA USERNAME ---------------------------------------- --- ------------------------------ SYS.INCVID ALTER                                    NO  SYSTEM SYS.INCVID DEBUG                                    NO  SYSTEM SYS.INCVID DELETE                                   NO  SYSTEM OBJ ------------------------------------------------------------- WHAT_GRANTED                             GRA USERNAME ---------------------------------------- --- ------------------------------ SYS.INCVID FLASHBACK                                NO  SYSTEM SYS.INCVID INDEX                                    NO  SYSTEM SYS.INCVID INSERT                                   NO  SYSTEM OBJ ------------------------------------------------------------- WHAT_GRANTED                             GRA USERNAME ---------------------------------------- --- ------------------------------ SYS.INCVID ON COMMIT REFRESH                        NO  SYSTEM SYS.INCVID QUERY REWRITE                            NO  SYSTEM SYS.INCVID REFERENCES                               NO  SYSTEM OBJ ------------------------------------------------------------- WHAT_GRANTED                             GRA USERNAME ---------------------------------------- --- ------------------------------ SYS.INCVID SELECT                                   NO  SYSTEM SYS.INCVID UPDATE                                   NO  SYSTEM SYS.IND$ SELECT                                   YES CTXSYS OBJ ------------------------------------------------------------- WHAT_GRANTED                             GRA USERNAME ---------------------------------------- --- ------------------------------ SYS.OBJ$ SELECT                                   NO  FLOWS_020100 SYS.OBJ$ SELECT                                   YES CTXSYS SYS.SYN$ SELECT                                   YES CTXSYS OBJ ------------------------------------------------------------- WHAT_GRANTED                             GRA USERNAME ---------------------------------------- --- ------------------------------ SYS.SYSAUTH$ SELECT                                   YES CTXSYS SYS.TAB$ SELECT                                   YES CTXSYS SYS.TS$ SELECT                                   YES CTXSYS OBJ ------------------------------------------------------------- WHAT_GRANTED                             GRA USERNAME ---------------------------------------- --- ------------------------------ SYS.USER$ SELECT                                   NO  XDB SYS.USER$ SELECT                                   YES CTXSYS SYS.USER$ SELECT                                   YES FLOWS_020100 OBJ ------------------------------------------------------------- WHAT_GRANTED                             GRA USERNAME ---------------------------------------- --- ------------------------------ SYS.VIEW$ SELECT                                   YES CTXSYS 49 rows selected. SQL>