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 to prove that user was created, can connect and can create tables and insert data.

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

3. As c##admin try to select data from the table you created in #2.

What is the result? Explain.

4. Fix the error you received in #3

query you used

screenshots to show results

5. 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

6. Alter the common user c##admin

query you used to drop the user

screenshots to prove that user was dropped

7. Drop the common user c##admin

query you used to drop the user

screenshots to prove that user was dropped

8. 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.

Answer 1

CREATE USER user_name 
  IDENTIFIED { BY password
             | EXTERNALLY [ AS 'certificate_DN' ]
             | GLOBALLY [ AS '[ directory_DN ]' ]
             }
  [ DEFAULT TABLESPACE tablespace
  | TEMPORARY TABLESPACE
       { tablespace | tablespace_group }
  | QUOTA integer [ K | M | G | T | P | E ]
        | UNLIMITED }
        ON tablespace
    [ QUOTA integer [ K | M | G | T | P | E ]
        | UNLIMITED }
            ON tablespace
    ]
  | PROFILE profile_name
  | PASSWORD EXPIRE
  | ACCOUNT { LOCK | UNLOCK }
     [ DEFAULT TABLESPACE tablespace
     | TEMPORARY TABLESPACE
         { tablespace | tablespace_group }
     | QUOTA integer [ K | M | G | T | P | E ]
           | UNLIMITED }
           ON tablespace
       [ QUOTA integer [ K | M | G | T | P | E ]
           | UNLIMITED }
           ON tablespace
        ]
     | PROFILE profile
     | PASSWORD EXPIRE
     | ACCOUNT { LOCK | UNLOCK } ]
     ] ;