DCL is also known as DATA CONTROL LANGUAGE.It is used to create roles, permissions, and referential integrity.Moreover,It is used to control access to database by securing it.Statements included under DCL are:
1)GRANT
2)REVOKE
GRANT:
It is used to grant privileges at specified access level. Syntax:
GRANT privilege[....]
ON object[,.....]
TO { PUBLIC | GROUP | USERNAME};
REVOKE:
The REVOKE statement enables system administrators to revoke privileges from MySQL accounts.
Do you like this article? Share It!
0 comments to "DATA CONTROL LANGUAGE"
Post a Comment