What are roles? How can we implement roles?

What are roles? How can we implement roles?

Roles in oracle restrict access to the different database objects. They are most useful when there are many database users. Once a role is created it can be granted to a user.


Create a role:-
Create role select_data;
Grant select on student. Employee, salary to select_data

Grant to a user:
Grant select_data TO John;

Revoke a role:-
Revoke select_date FROM John;

What are roles? How can we implement roles?

A role is a set or group of privileges that can be granted to users or another role.

Following examples illustrate the way to create them:
CREATE ROLE role_user1;

This example simply creates a role called test_role.
CREATE ROLE role_user2

This example creates the same role and has an associated password with it.
What is user Account in Oracle database?
A user account is a schema which is used to store database objects, applications, and components.....
What is a trace file and how is it created?
The files that are created when an oracle background process encounters an exception are Trace files......
What are Tablespace Quota and default tablespace?
A tablespace is a logical storage unit within an Oracle database because it is not visible in the file system of the machine, the database resides on.....
Post your comment