Database question 2.You created a new user on the database by executing the following command: SQL> CREATE USER user01 IDENTIFIED BY user01 DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp; Then you granted the following privileges to user01 by executing the following command: SQL> GRANT CREATE SESSION, CREATE TABLE TO user01; Which of the following is true in this scenario? a) The user can not create tables b) The user can create tables c) The user cannot query any tables d) None of the Mentioned
Database question 2.You created a new user on the database by executing the following command: SQL> CREATE USER user01 IDENTIFIED BY user01 DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp; Then you granted the following privileges to user01 by executing the following command: SQL> GRANT CREATE SESSION, CREATE TABLE TO user01; Which of the following is true in this scenario? a) The user can not create tables b) The user can create tables c) The user cannot query any tables d) None of the Mentioned
Chapter7: User Creation And Management
Section: Chapter Questions
Problem 16MC
Related questions
Question
2.You created a new user on the database by executing the following command:
SQL> CREATE USER user01 IDENTIFIED BY user01
DEFAULT TABLESPACE users
TEMPORARY TABLESPACE temp;
Then you granted the following privileges to user01 by executing the following command:
SQL> GRANT CREATE SESSION, CREATE TABLE TO user01;
Which of the following is true in this scenario?
a) The user can not create tables
b) The user can create tables
c) The user cannot query any tables
d) None of the Mentioned
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning