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 should be also a system privilege
ALTER ANY TABLE would be a system privilege (allows modification of tables owned by other users).
ALTER TABLE privileges (your own tables) are included in the CREATE TABLE privilege it seems.
The difference between CREATE and ALTER seems to be that there are:
CREATE ANY TABLE (allows creation of tables for other users) and
CREATE TABLE (allows creation/and modification of tables owned by that user)
So only E imho