SQLSESSION38 | SQL Server User Permissions, Roles & Stored Procedures | Real-Time DBA Scenarios
In this video, we cover real-time SQL Server DBA tasks including user creation, permission management, schema access, and stored procedures.
🔹 Topics Covered:
Working with ticketing tools & requirement gathering
How to ask developers for exact permissions (roles vs object-level access)
Checking if login exists using filters
Creating users with SELECT access on tables
Handling common requests like:
Database access
Backup permissions
Cloning permissions from another user (like Amar)
Important checks before creating a user:
Server & Instance name
Authentication type (Windows / SQL)
Scope of access (tables / schemas / full DB)
Schema validation
🔐 Schema-Based Permission Scenario:
Cross-access between users (L1 & L2 schemas)
Granting SELECT permissions between schemas
📌 Hands-on SQL Examples:
💡 Key Takeaways:
Always confirm requirements before granting permissions
Use schema-based access for better security control
Reuse permissions efficiently by scripting existing users
Grant only required permissions (principle of least privilege)
This tutorial is perfect for beginners and working DBAs who want to handle real-world scenarios confidently.
#SQLServer #DBA #UserManagement #StoredProcedure #SQLTutorial #DatabaseSecurity