SQLsession34| SQL Server Fixed Database Roles Explained | Permissions, GRANT & DENY with Examples
In this video, we dive deep into SQL Server Fixed Database Roles and how permissions work in real-time scenarios. This session is perfect for beginners and DBAs who want to understand role-based security in SQL Server.
👉 Topics covered in this video:
Overview of Fixed Database Roles (DBO, db_owner, db_datareader, db_datawriter, etc.)
Understanding permission types:
GRANT
DENY (and why DENY overrides GRANT)
Explanation of key roles:
Data Reader & Data Writer
Deny Data Reader & Deny Data Writer
Access Admin & Security Admin
DDL Admin
Backup Operator
DB Owner (Full Control)
Creating and managing users:
Create User for Login
Drop User
Hands-on SQL examples:
Creating a table
Inserting and selecting data
Granting permissions:
SELECT, INSERT, UPDATE, DELETE, ALTER
WITH GRANT OPTION
Understanding:
Database-level vs Schema-level vs Object-level permissions
Securables concept in SQL Server
💡 Key Concept:
Even if permissions are granted, a DENY will always override GRANT, especially at different levels like database, schema, or object.
📌 Example used in the video:
Create table employee (sno int, sname varchar(50))
Insert into employee values (1, 'one')
Select * from employee
👍 If you're preparing for SQL Server DBA interviews or learning database security, this video is a must-watch!
🔔 Don’t forget to Like, Share, and Subscribe for more SQL Server tutorials.