Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> System vs object privileges

System vs object privileges

From: Peter <peter_at_nomorenewsspammin.ca>
Date: Mon, 23 Jun 2003 07:22:27 GMT
Message-ID: <jg9dfvg1m6qm6lupihlvbgn03a4augmmr5@4ax.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US