Clause with admin option allows the grantee to grant

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

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. Incorrect Answers: 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 QUESTION 19: Which view will show a list of privileges that are available for the current session to a user? A. SESSION_PRIVS B. DBA_SYS_PRIVS C. DBA_COL_PRIVS D. DBA_SESSION_PRIVS Answer: A Explanation: Answer A is correct. SESSION_PRIVS will show a list of privileges that are available for the current session to a user. Incorrect Answers: 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. D:...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online