There are no cascading effects when revoking a system

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: ge related to DDL operations, regardless of whether the privilege was granted with or without the ADMIN OPTION. Cascading effects can be observed when revoking a system privilege related to a DML operation. For example, if SELECT ANY TABLE is granted to a user, and if that user has created any procedures, then all procedures contained in the user's schema must be reauthorized before they can be used again (after the revoke). Incorrect Answers: A: User B will lose the ALTER USER privilege. C: The roles will remain and User B will not lose the ALTER USER privilege. D: The roles will remain. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 485-489 Chapter 10: Managing Database Use QUESTION 127: What are three examples of system privileges? (Choose three) - The Power of Knowing 1Z0-023 A. UPDATE B. EXECUTE C. REFERENCES D. CREATE TABLE E. ALTER ANY INDEX F. CREATE SESSION Answer: D, E, F Explanation: Answers D, E and F are correct. CREATE TABLE, ALTER ANY INDEX, CREATE SESSION are system privil...
View Full Document

Ask a homework question - tutors are online