Question
In oracle pl/sql do not copy and paste from another answered question. Create a common user c##admin query you used to create the user screenshots
In oracle pl/sql do not copy and paste from another answered question.
Create a common user c##admin
query you used to create the user
screenshots to prove that user was created, can connect and can create tables and insert data.
- Use system account to create a table TEST_TABLE_SYSTEM with at least one column and add at least one row. Do not forget to commit.
query you used to create the table
screenshots to show the content
- As c##admin try to select data from the table you created in #2.
What is the result? Explain.
- Fix the error you received in #3
query you used
screenshots to show results
- Use Oracle data dictionary to check what permissions you granted to the user c##admin.
query you used to drop the user
screenshots to prove that user was dropped
- Alter the common user c##admin
query you used to drop the user
screenshots to prove that user was dropped
- Drop the common user c##admin
query you used to drop the user
screenshots to prove that user was dropped
- What procedures would you follow if you were told that an employee was terminated? Hint: This is a tricky question and includes not only Oracle commands.
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
Oracle Solaris 11.2 System Administration (oracle Press)
Authors: Harry Foxwell
1st Edition
007184421X, 9780071844215
