Which data dictionary category would a user with the SELECT ANY TABLE privilege query to find the owner of the PRODUCT1 table?
The data dictionary views categories: ALL_ Accessible to all users and each view has an OWNER column, providing information on objects accessible by the user DBA_ Accessible to the DBA or anyone with the SELECT ANY TABLE privilege, providing information on all the objects in the database and has an OWNER column USER_ Accessible to all users, providing information on objects owned by the user
Related Questions
- Which data dictionary category would a user with the SELECT ANY TABLE privilege query to find the owner of the PRODUCT1 table?
- Which data dictionary view could you query to display the number of blocks used by a table in each datafile ?
- Which data dictionary view could a user query to display the number of bytes charged to their username?
