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.



Leave a Reply 0

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