System Privileges
|
Table Level Privileges
(Object Level)
|
System Privileges
are normally granted by a DBA to users.
|
Object privileges
means privileges on objects such as tables, views, synonyms, procedure. These
are granted by owner of the object.
|
This
privileges allows a user to manage database and server.
|
This
privileges allows a user to perform certain action upon certain database
objects
|
List
of privileges
·
CREATE USER
·
CREATE TABLE
·
CREATE SESSION
|
List
of privileges
·
SELECT
·
INSERT,UPDATE,DELETE
·
EXECUTE
|
To get information
about system level privileges
·
SELECT
* FROM USER_SYS_PRIVS
·
SELECT
* FROM ROLE_SYS_PRIVS
|
To get information
about object level privileges
·
SELECT
OWNER,TABLE_NAME,PRIVILEGE
FROM USER_TAB_PRIVS
·
SELECT
* FROM ROLE_TAB_PRIVS
|
Syntax
GRANT privileges TO
username;
|
Syntax
GRANT privileges ON object
TO username;
|
Example
GRANT CREATE
SESSION, CREATE PROCEDURE
TO PARAG;
|
Example
GRANT SELECT, INSERT
ON EMPLOYEE
TO PARAG;
|
 |
 |
SYSTEM LEVEL PRIVILEGES AND OBJECTS LEVEL PRIVILEGES
