TCL COMMANDS

 TCL COMMANDS

DCL(data control language)

Grant

Revoke

SQL PRIVILEGES

Privilege is a permission given by DBA

It provides right to execute a particular type of sql statements

It also gives the right to connect the database and create a table in your schema.

Note: sql DCL command deals with privileges                                      PRIVILEGES CAN BE DERIVED INTO TWO PARTS

System privileges[DDL]

Object privileges[DQL,DML]                

 SQL PROVIDES TWO DCL COMMAND TO MANIPULATE THE PRIVILEGES

GRANT: It hepls to provide any kind of access to any user

REVOKE: It is used to take back the access from users

TCL COMMANDS

Create user sha identified by pwd;

User created

 Grant connect to sha;

Grant succeeded

 Grant select on system to sha;

Grant delete on emp to sha;

Grant succeeded

 Grant all on emp to sha;

Grant succeeded

 

Revoke all on system.emp from sha;

Revoke succeeded

 Revoke connect from sha;

Revoke succeeded