SQL Server DBA Tutorial 58- How to Create Database Role in SQL Server

In this video you will learn how to create database role in SQL Server databases using SQL Server Management studio as well as T-SQL Script. This video demonstrates best practices of creating user defined database roles, how to add users to newly created database roles, how to add database objects to a database role.

Blog post link for this video:

Visit our website to check out SQL Server DBA Tutorial Step by Step

[nocchio]

I tried to learn the way to add a table to each rol, and you were the only one who did it. Thank so much, i appreciate your time to record this video.

[efraincaceres]

Good evening, and thank you. This video safe me a lot, I'm doing my thesis and believe when I say this is the easiest video that I could have seen. Greetings. I am sorry if my English is not good, but believe that I understand every single explanation that you did on the video.

[jrod]

Thank you! it's a very good training. It helped me a lot!

[iboadam]

Hi Techbrothers. Want to appreciate all you guys do to educate us. Please I have a scenario in my environment:
So the data analyst need to be creating their tables so the need DB-owner permission but now I need to restrict their access to production tables to only read from it but also they do need DB-owner permission to create and drop the their own summary tables. How do I go around this. I have tried all i cold but can get around it. Thanks for your help

[paragkambli]

USE [SalesOrders]
GO 
ALTER AUTHORIZATION
GO 

Is it possible to transfer schema to a role?
Or it is transferred to user who owns that role?

[irfanhasan]

I just want to create a custom role only for Insert/create anything (table, table data, SP etc) but not alter permission, how can i do it? any link will be helpful for me