SQL DCL Commands- Data Control Language
TUTORIAL IN HINDI:
DCL commands are used to grant and take back authority from any database user.
GRANT – It permits users to access the database.
SYNTAX:
GRANT SELECT, UPDATE, DELETE ON My_Table To Some_User , Another_User;
--------------------------------------------------------------------------------------
REVOKE – This SQL DCL command withdraws the permission given by GRANT to access the database.
SYNTAX:
REVOKE SELECT, UPDATE, DELETE On My_Table From User1, User2;
--------------------------------------------------------------------------------------
However numerous assets guarantee there to be one more classification of SQL provisos TCL - Transaction Control Language. So we will find exhaustively about TCL also.
TCL orders manage the exchange inside the information base.
Rundown of TCL orders:
Submit: Commits a Transaction.
ROLLBACK: Rollbacks an exchange if there should arise an occurrence of any mistake happens.
SAVEPOINT: Sets a savepoint inside an exchange.
SET TRANSACTION: Specify qualities for the exchange.
--------------------------------------------
Follow Us :-
0 Comments