Name few of the DCL commands in SQL?

devquora
devquora

Posted On: Feb 22, 2018

 

The commands which are used to create the rules to grant the permission are known as useful commands in SQL. These commands also control the access to the database and its objects.

  • Grant - it provides the user access
  • Deny - it denies permissions given to users
  • Revoke - this command remove the user access.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    SQL Server Interview Questions

    What are a database and a data warehouse?

    A database, in general, is a collection of information in a more organized form for better access...

    SQL Server Interview Questions

    What is normalization according to you and explain its different levels?

    In order to remove the redundant data, normalization is used. It also reduces the null values and enables the efficiency of indexing...

    SQL Server Interview Questions

    What do you understand by the denormalisation?

    Denormalization is the inverse process of normalization...