Question
I have following assigment and I am not sure how to do this. I started database and did spool command what are my next steps,
I have following assigment and I am not sure how to do this. I started database and did spool command what are my next steps, please help!
Run sqlplus system/Oracle11 and SPOOL to c:\cis421b\S6spool.txt
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.
Submit c:\cis421b\S6spool.txt
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started