Predefined users and roles includes 2 process i.e, allowing only certain clients to access and implementing various limits on clients for accessing.
The restrictions issued on client can be applied on objects like table rows,table columns and schemas. To run a particular sql statement must be implemented by a client privilege or another client is responsible for accessing the object, that run pl/sql package. All this privileges are predefined for oracle database. User is responsible for creating the roles for including other privileges or other different roles. And granting all this privileges to clients includes the following facilities and can classified into different categories.
- System privileges
- Roles
- Object privileges
- Table privileges
- View privileges
In the database these privileges perform standard administrator tasks and can restrict them for trusted clients only and includes the following tasks like
- Managing system privileges
- Managing administrative privileges
- Managing locally and commonly privileges for granted
It contain many standard roles and privileges, so simultaneously a user an grant and revoke this operations. For enabling these roles the user has to perform the necessary roles such as
- Managing local and common roles
- Managing roles of clients
All the types of object contain necessary privileges associated with it,like managing object privileges. The privileges are different for different objects.
The data definition language and data manipulation language privileges can be made enable under this security. And these privileges explain how to control table privileges.
For viewing this views privileges data manipulation language is used, and these views are similar to tables.