Which one is a system privilege?
A.
SELECT
B.
DELETE
C.
EXECUTE
D.
ALTER TABLE
E.
CREATE TABLE
Which one is a system privilege?
Which one is a system privilege?
Leave a Reply
Which one is a system privilege?
Which one is a system privilege?
A.
SELECT
B.
DELETE
C.
EXECUTE
D.
ALTER TABLE
E.
CREATE TABLE
Alter table is system privileges!
Actually, it’s not. See here:
SQL> connect SYSTEM
Enter password:
Connected.
SQL> REVOKE CREATE TABLE FROM JOHN;
Revoke succeeded.
SQL> REVOKE ALTER TABLE FROM JOHN;
REVOKE ALTER TABLE FROM JOHN
*
ERROR at line 1:
ORA-00990: missing or invalid privilege
ALTER TABLE is a system privilege per Oracle’s documentation:
http://docs.oracle.com/cd/E21901_01/timesten.1122/e21642/privileges.htm#TTSQL339
This is clearly listed in the system privileges section:
ALTER ANY TABLE … Enables a user to alter any table in the database.
So the correct answer is D&E
ALTER ANY is a System privilege, ALTER TABLE is an object privilege,
albeit CREATE ANY, and CREATE TABLE are System privileges,
thanks Vincent for doc’ reference