Which of the following commands is valid?
A) GRANT SELECT,UPDATE ANY TABLE
ON orders
TO rthomas;
B) GRANT SELECT
ON orders
TO rthomas
WITH ADMIN OPTION;
C) GRANT SELECT
ON orders
TO rthomas,jdoe;
D) none of the above

Question

Which of the following commands is valid?
A) ​GRANT SELECT,UPDATE ANY TABLE
ON orders
TO rthomas;
B) ​GRANT SELECT
ON orders
TO rthomas
WITH ADMIN OPTION;
C) GRANT SELECT
ON orders
TO rthomas,jdoe;
D) none of the above

Quizplus · Accepted Answer

Option A is invalid as it does not specify which tables the user has the permission to SELECT and UPDATE. Option B is valid but includes an unnecessary specification of the WITH ADMIN OPTION. Option C is correct as it specifies the SELECT permission on the "orders" table to both "rthomas" and "jdoe". Option D is not the right answer as option C is valid.

Which of the Following Commands Is Valid