The book I am using is Beginning Oracle Database 11g Administration From Novice

Question

The book I am using is Beginning Oracle Database 11g Administration From Novice to Professional, Chapter 8. Run sqlplus system/Oracle11 and SPOOL to spool.txt (Please post text from spool.txt)

Instructions:
User SCOTT, who had the password TIGER, changed it to something more secure, but has since forgotten it. If possible, demonstrate what you as a DBA can do to give SCOTT access to his account.
Other users need access to the tables belonging to IGGY. Create a role named CLERK that has SELECT privileges for tables PART, SUPPLIER, and QUOTE.
Assign the role CLERK to user SCOTT. Connect as user SCOTT and SELECT * FROM QUOTE.

Explanation / Answer

DEAR... WITH GRANT OPTION it allows to grant the object privileges to other users and roles. The grantee must be a user or PUBLIC, rather than a role. A privilege cannot appear more than once in the list of privileges to be granted. A user or role cannot appear more than once in the TO clause. It can allow changing the user name and password as OE and Scoot are the users in the database CREATE ROLE CLERK GRANT SELECT, INSERT ON oe. Orders TO CLERK; GRANT r1 TO scott; GRANT SELACT ON oe.SUPPLIER TO scott; REVOKE SELECT ON oe. SUPPLIER FROM QUOTE.

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.