SQL Command DCL
DCL (Data Control Language) The data in the database is an important asset of any organization. It shouldn’t be provided to all the users instead each and every user should be provided access to the data according to some privileges and rights. All this should be done to secure the data from illegal access. DBMS (Database Management System) should provide the mechanism to ensure that only the authorized user can access the data. Each user is given appropriate access rights to specific data objects (tables and views). In SQL these privileges and access rights can be assigned by the commands. What is DCL? DCL is a Data Control Language that contains commands related to assigning user rights and privileges. These commands are Grant and Revoke commands. Grant command: Grant command is used to provide access rights on database objects to specific users. Normally Grant statement is used by the owner of the table to provide access to the other users. The user who creates th...