Unknown

Oracle 11g -(Class 10)-Oracle 11g -SQL Statement







User is very important part of oracle database, without them no action happen in database. For this user must give privileges to access other objects on the database.

How to create a role :





SQL> Create role clock;

Role created.

One role created as a name of clock

Now we will included privilege against this clock role





SQL> Grant create table, create any table to clock;







Grant succeeded.

Now we can grant this role to any user







SQL > Grant Clock to SHAIKATUSTC09;









Very important DATA_DICTIONARY:





DBA_SYS_PRIVS = system privileges





DBA_TAB_PRIVS = object privileges





grantee = person receiving





grantor = person providing





Now we will see 'Shaikatustc09' all privilege :





SQL> SELECT * FROM DBA_ROLE_PRIVS where grantee='SHAIKATUSTC09';

Given Below Some important Query to check all role & privilege:

SELECT * FROM DBA_SYS_PRIVS WHERE GRANTEE='SHAIKATUSTC09';

SELECT * FROM DBA_ROLE_PRIVS WHERE GRANTEE='SHAIKATUSTC09';

SELECT * FROM ROLE_SYS_PRIVS WHERE ROLE = 'CLOCK';

Note: In Next Tutorial - 11 We will discuss DDL & DML In SQL SERVER

& Next Tutorial will be Post on 9th September after Completed my Vacation.Till then take care and Share my blog to others,& keep follow me on google plus.

Reactions:

*******************Thank You ************************