What privileges does the user Scott have at this point?

The DBA issues this SQL command:
CREATE USER scott IDENTIFIED by tiger;
What privileges does the user Scott have at this point?

The DBA issues this SQL command:
CREATE USER scott IDENTIFIED by tiger;
What privileges does the user Scott have at this point?

A.
no privileges

B.
only the SELECT privilege

C.
only the CONNECT privilege

D.
all the privileges of a default user

Explanation:
when a user is created, by default no privilege is granted
Incorrect answer:
BSELECT is not grant
CCONNECT is not grant
Ddefault profile is grant by default not privilege.

Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 13-6



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Bina

Bina

To get a privilege the query has to mention grant or revoke in the statement.