Here, I am using Oracle 11g 1) Run sqlplus system/Oracle11 and SPOOL to c:\cs421\S7spool.txt

2) 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.

3) 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.

4) Assign the role CLERK to user SCOTT. Connect as user SCOTT and SELECT * FROM QUOTE.