This preview shows page 1. Sign up to view the full content.
Unformatted text preview: COL_PRIVS
Answer C is correct. You can find information about system privileges granted to all users in the
A: DBA_PRIVS view shows all available privileges, disregarding of privileges for users.
B: DBA_TAB_PRIVS view shows privileges on tables, not system privileges for users.
D: DBA_COL_PRIVS view as DBA_TAB_PRIVS view provides information about the object
privileges granted in the database. Actualtests.com - The Power of Knowing 1Z0-023
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 489
Chapter 10: Managing Database Use
User A grants the SELECT privilege WITH GRANT OPTION on the table EMP to User
B. User B then grants SELECT on a EMP to User C. What will happen if User A revokes
User B's SELECT privilege?
A. User B will not be able to SELECT, and User C will be unaffected.
B. An error will occur unless User B first revokes SELECT from user C.
C. Nothing, unless the CASCADE CONSTRAINTS option was used.
D. Both User B and User...
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09