- oracle tutorial - sql tutorial

DCL Commands in Oracle | Data Control Language - oracle tutorial - sql tutorial - oracle tutorial - sql tutorial




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

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

Related Searches to DCL Commands in Oracle | Data Control Language

Adblocker detected! Please consider reading this notice.

We've detected that you are using AdBlock Plus or some other adblocking software which is preventing the page from fully loading.

We don't have any banner, Flash, animation, obnoxious sound, or popup ad. We do not implement these annoying types of ads!

We need money to operate the site, and almost all of it comes from our online advertising.

Please add wikitechy.com to your ad blocking whitelist or disable your adblocking software.

×