Day 15 — DCL (Data Control Language)

What is DCL in SAP HANA? Why is it important?

DCL (Data Control Language) is used to control user access and permissions in the database. 1. What is DCL? a. Controls database security. b. Manages user permissions. c. Protects sensitive business data. d. Allows administrators to grant or revoke access. e. Ensures authorized users access the database. 2. Common DCL Commands a. GRANT – Gives permissions to a user. b. REVOKE – Removes permissions from a user. 3. Why Do We Use DCL? a. Improve database security. b. Restrict unauthorized access. c. Control user privileges. d. Protect confidential information. e. Manage different user roles.

• A new employee joins the Finance team. • The Database Administrator creates a user account. • GRANT command provides access to Finance tables. • The employee cannot access HR data. • When the employee leaves the company, the REVOKE command removes all permissions.

1. What is DCL? 2. Name the DCL commands. 3. What is the purpose of the GRANT command? 4. What is the purpose of the REVOKE command? 5. Give one real-time example of DCL.