What is Data Control Language in Oracle ?

• Data Control Language Statements are used to grant privileges on tables, views, sequences, synonyms, procedures to other users or roles. Privileges are of two types :
• System Privileges
• Object privileges

oracle tutorial , sql tutorial , sql , pl sql tutorial , oracle , pl sql , plsql

System Privileges :

• System Privileges are normally granted by a DBA to users.
• Examples of system privileges are CREATE SESSION, CREATE TABLE, CREATE USER etc.

Object privileges :

• Object Privileges means privileges on objects such as tables, views, synonyms, procedure. These are granted by owner of the object. The DCL statements are,
• GRANT : Use to grant privileges to other users or roles.
• REVOKE : Use to take back privileges granted to other users and roles.

Oracle grant revoke deny functions

This tutorial provides an indepth knowledge on the following items such as oracle tutorial , sql tutorial , sql , pl sql tutorial , oracle , pl sql , mysql tutorial , sql tutorial for beginners , learn sql , oracle database tutorial , sql query tutorial , oracle dba tutorial , plsql tutorial , oracle tutorial pdf , oracle pl sql tutorial , oracle sql tutorial , sql tutorial point , oracle tutorial for beginners , learn oracle online free , learn oracle online , learning pl sql programming , learn sql online for free , sql learning online , dba oracle tutorial , oracle sql tutorial advanced , oracle 11g dba tutorial with examples , oracle online learning , oracle learning online , how to learn pl sql , sql coding tutorial , sql learning websites , sql basic learning