What are the kinds of roles in oracle?

What are the kinds of roles in oracle?

Following are the kinds of roles available in oracle:

Connect
This role allows access to the table belonging to other users. It allows using Select, Insert, Update and Delete command.

Resource
With this role, one can create his own tables, sequences, procedures, triggers, indexes and clusters.

DBA
It has system privilege and can grant those privileges to other.
Define primary key and foreign key
Define primary key and foreign key - A column or combination of columns that identify a row of data in a table is Primary Key. A key in a table that identifies records in other table in called a foreign key....
Explain how to DISABLE and ENABLE constraint
Explain how to DISABLE and ENABLE constraint in Oracle - Disable a constraint by using the DISABLE clause......
Statement Auditing, Privilege Auditing and Object Auditing in oracle
Define Statement Auditing, Privilege Auditing and Object Auditing in oracle - Statement auditing is the auditing of the powerful system privileges without regard to specifically named objects.....
Post your comment

Related Content

Follow us

▲