Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> System vs object privileges
Why is an alter on the definition of a table or a sequence an object
privilege?
According to the manual, "alter any table" and "alter any sequence"
are system privileges. Most other "alter" privileges are system
privileges.
The "create table" privilege also includes the "create index" system
privilege.
So why is creating an index on a table an object privilege, when
"create any index" a system privilege?
Thanks Received on Mon Jun 23 2003 - 02:22:27 CDT