A user in Oracle must have which of the following privileges in order to create objects like tables, views, etc.?
-
Connect
-
Admin
-
Create User
-
Resource
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)