Multiple choice technology databases

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

  1. no privileges

  2. only the SELECT privilege

  3. only the CONNECT privilege

  4. all the privileges of a default user
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

When a user is created with CREATE USER, they have no privileges at all - not even the ability to log in. The user must be explicitly granted privileges (like CREATE SESSION) before they can do anything. Options B, C, and D are incorrect - no default privileges are granted.

Keep practicing — related questions