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
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
When you create a user with the CREATE USER statement, the user’s privilege domain is empty.
https://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_8003.htm