Name
Tables
Synopsis
Provides privileges to perform operations on tables.
Unique privileges
- INDEX
Creates an index on the table.
- ON COMMIT REFRESH
Creates a materialized view that is refreshed on a COMMIT operation. New with Oracle9i.
- QUERY REWRITE
Creates a materialized view for query rewrite on a specific table.
Common privileges
ALTER, DELETE, DEBUG, FLASHBACK, INSERT, REFERENCES, SELECT, UPDATE.
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.