DCL Commandss
DCL includes commands such as GRANT and REVOKE which mainly deal with the rights, permissions, and other controls of the database system.
- GRANT
- REVOKE
Aptitude
- Introduction
- File System vs DBMS
- Tuple
- Record
- Architecture
- Need of DBMS
- DBMS Abstraciton and Indipendence
- Data Models
- ER Models
- RDBMS
- Relational Data Model
- SQL Introduction
- SQL Types
- DDL Commands
- DQL Commands
- DML Commands
- DCL Commands
- TCL Commands
- Default Constraints
- Check Constraint
- Not Null Constraint
- Unique Constraint
- Key Constraint
- Key In DBMS
- Primary Key
- Foreign Key
- Super Key
- Candidate Key
- Alternate Key
- Composite Key
ER Models
RDBMS
SQL
SQL Constraints
Keys In DBMS
SQL DCL Commands
GRANT Command
This command gives users access privileges to the database.
We have already learned about how to create user in MySQL using MySQL | create user statement. But using the Create User Statement only creates a new user but does not grant any privileges to the user account.Therefore to grant privileges to a user account, the GRANT statement is used.
Syntax
GRANT privileges_names ON object TO user;
Parameters Used:
- privileges_name: These are the access rights or privileges granted to the user.
- object:It is the name of the database object to which permissions are being granted. In the case of granting privileges on a table, this would be the table name.
- user:It is the name of the user to whom the privileges would be granted.
Privileges:
The privileges that can be granted to the users are listed below along with description:
| Privilage | Description |
|---|---|
| SELECT | Select statement on tables. |
| INSERT | Insert statement on the table |
| DELETE | Delete statemnet on the table |
| INDEX | Create an index on an existing table |
| CREATE | Create table statement |
| ALTER | Ability to performe ALTER TABLE to change the table definition |
| DROP | Drop table statement |
| ALL | Grant all permission exept GRANT OPTION |
| UPDATE | Update statement on the table |
| GRANT | Allows to grant the privilage |
Let us now learn about different ways of granting privileges to the users:
- Granting SELECT Privilege to a User in a Table: To grant Select Privilege to a table named “users� where User Name is Amit, the following GRANT statement should be executed.
ALTER TABLE table_name ADD(column_name datatype);
→
←