Data Control Language Dcl For Database Permissions
DCL is the simplest of the SQL subsets, as it consists of only three commands: GRANT, REVOKE, and DENY. Combined, these three commands provide administrators with the flexibility to set and remove database permissions in granular fashion. Adding Permissions With the GRANT Command The GRANT command adds new permissions to a database user. It has a very simple syntax, defined as follows: Here’s the rundown on each of the parameters you can supply with this command:...