Which two statements are true about *_TABLES views? (Choose two.)
Which two statements are true about *_TABLES views? (Choose two.)
USER_TABLES displays all tables owned by the current user. You must have ANY TABLE system privileges, or be granted object privileges on the table, to view a table in DBA_TABLES. Other options regarding ALL_TABLES and DBA_TABLES rules do not fully capture the specifics of these views or required permissions accurately.
AD. Tried on ORA 19. GRANT SELECT ANY_TABLE to gives access to DBA_TABLES F is incorrect because querying ALL_TABLES you can always do but only see those tables you have the rights to view, which would be a subset of DBA_TABLES
i am for AF
AF cannot grant dba_tables privilege
Explain all answers
Don't get USER_TABLE and ALL_TABLE views confused. A) USER_TABLES displays all tables owned by the current user. (True) E) ALL_TABLES displays all tables owned by the current user. (False) The ALL_TABLES view contains description of tables accessible to the user.
AD , the right answers. The data dictionary views that begin with DBA_ are restricted. These views can be accessed only by users with the SELECT_ANY_TABLE privilege. This privilege is assigned to the DBA role when the system is initially installed. https://docs.oracle.com/cd/A57673_01/DOC/server/doc/SRF73/ch2a.htm
granting select any table to my user did not allow him to query dba_tables
if you don't have dba role then you will get message that DBA_TABLES doesn't exist. DBA_TABLES is a data dictionary view
AD to view dba_table should have privilege.
AF is the right answer anyday. USER_TABLE - dictionary view which has list of tables owned by the user ALL_TABLE - dictionary view which has list of tables owned by the user + tables which user has grants for. DBA_TABLE - All tables in database(but you should have dba privelege to see them)
I tried D and it doesn't work for me!!!! But its probably A. idk about the 2nd option
A, F are correct