Which two are true about granting object privileges on tables, views, and sequences? (Choose two.)
Which two are true about granting object privileges on tables, views, and sequences? (Choose two.)
SELECT can be granted on tables, views, and sequences, allowing users to read data from these objects. REFERENCES can be granted only on tables, providing permission to create foreign key constraints that reference the table. ALTER cannot be granted on views, hence option C and option E are true.
The following OBJECT PRIV'S can be granted on tables, views and sequences--- UPDATE: tables, views. REFERENCES: tables, views ALTER: tables, sequences. SELECT: tables, views, sequences
CE, according to this site: https://docs.oracle.com/database/121/TTSQL/privileges.htm#TTSQL338 A. INSERT can be granted only on tables and sequences. (FALSE, table + synonym) B. DELETE can be granted on tables, views, and sequences. (FALSE, only table) C. SELECT can be granted on tables, views, and sequences. (TRUE) D. ALTER can be granted only on tables and sequences. (FALSE, ALTER is system priv. not object) E. REFERENCES can be granted only on tables. (TRUE, tables + materialised views, which are different than 'normal' views)
But answer E mentioned only on Table so E is clearly wrong :D It didnt mention and "materialised views" it said Tables "only" which is wrong. So i think C & D is correct.
UPDATE: tables, views. REFERENCES: tables, views ALTER: tables, sequences. SELECT: tables, views, sequences. DELETE: tables, views. INSERT: tables, views. Doc: https://docs.oracle.com/en/database/oracle/oracle-database/23/sqlrf/GRANT.html#GUID-20B4E2C0-A7F8-4BC8-A5E8-BE61BDC41AC3__BGBCIIEG
C and D
C and D because you can grant References on a view. Tried out! :)