Unformatted text preview: ause WITH ADMIN OPTION allows the grantee to grant or revoke the
system privilege to other users and roles. Additionally it gives grantee the ability to make other
users administrators of that same privilege.
A: There is no PUBLIC clause in GRANT command.
B: There is no WITH PRIVILEGE clause in GRANT command.
D: Clause WITH GRANT OPTION is used to grant object privilege, not system one.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 486
Chapter 10: Managing Database Use
Which view will show a list of privileges that are available for
the current session to a user?
Answer A is correct. SESSION_PRIVS will show a list of privileges that are available for the
current session to a user.
B: DBA_SYS_PRIVS view identifies all the role and user grantees and granted system
privileges to those roles and users.
C: There is no DBA_COL_PRIVS view in Oracle.
View Full Document
- Fall '09
- Oracle Database, Jason S. Couchman, DBA Certification Exam, Certification Exam Guide