Multiple choice

A user in Oracle must have which of the following privileges in order to create objects like tables, views, etc.?

  1. Connect

  2. Admin

  3. Create User

  4. Resource

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The resource role allows a user to create and modify new objects like Table, View etc. It is the basic permission that a user requires to create objects. When a user in Oracle is created, it is a two step process - first a new user is created by issuing the create user statement which is create user username identified by password;For example : create user amit identified amit_manager; Once the user is created , it is assigned permissions so that it can carry on with its work. To grant permissions, the create grant statement is issued. For example : Grant connect,resource to amit. This statement will permit the user amit to login(connect) and create objects(resource)