Which command will grant a system privilege to a user?
A) GRANT systemprivilege USERNAME username
B) GRANT PRIVILEGE systemprivilege TO username
C) GRANT systemprivilege TO username
D) GRANT systemprivilege ON username

Question

Which command will grant a system privilege to a user?​
A) ​GRANT systemprivilege USERNAME username
B) ​GRANT PRIVILEGE systemprivilege TO username
C) ​GRANT systemprivilege TO username
D) ​GRANT systemprivilege ON username

Quizplus · Accepted Answer

The correct syntax for granting a system privilege to a user is "GRANT systemprivilege TO username". Option A is incorrect because it requires the "ON" keyword before the object or schema for which the privilege is being granted. Option B is incorrect because it uses the incorrect sequence of keywords. Option D is incorrect because it uses the "ON" keyword without specifying the object or schema.

Which Command Will Grant a System Privilege to a User?​

Which Command Will Grant a System Privilege to a User?