Name
TABLE
Synopsis
Provides the ability to work with tables.
Unique privileges
- BACKUP ANY
Gives the privilege to use the Export utility on objects in other users’ schemas.
- COMMENT ANY
Gives the privilege to comment on any table, view, or column in any schema.
- INSERT ANY
Gives the privilege to insert rows into tables in other users’ schemas.
- LOCK ANY
Gives the privilege to lock tables and views in other users’ schemas.
- FLASHBACK ANY
Gives the ability to issue a SQL flashback query on any table, view, or materialized view in other users’ schemas. You can still use the DBMS_FLASHBACK built-in package’s procedures without this privilege. New with Oracle9i.
- UPDATE ANY
Gives the privilege to update rows in tables and views in other users’ schemas.
See the entry on FLASHBACK ANY TABLE under Miscellaneous Privileges.
Common privileges
CREATE [ANY] (CREATE supported only in Oracle8 and before), ALTER ANY, DELETE ANY, DROP ANY, SELECT ANY.
Get Oracle in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.