script to create role

Question

script to create role

charipg

SSCrazy Eights

Points: 9888
More actions
May 7, 2015 at 4:02 pm

#297957

Need a script to create a new role to cover SP creation/execution, any table data manipulation (insert, update, delete & select) .
Thank you !!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

charipg SSCrazy Eights Points: 9888 More actions · Answer 1

Actually I am struggling for a complete script

Need a script to create a new role in all databases to cover SP creation/execution, any table data manipulation (insert, update, delete & select) .

Thank you !!

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 2

charipg (5/7/2015)
Actually I am struggling for a complete script
Need a script to create a new role in all databases to cover SP creation/execution, any table data manipulation (insert, update, delete & select) .
Thank you !!

My recommendation is that it's time for you to study about privs. It's all in "Books Online". If you don't know what "Books Online" is, you might want to Google it because it's wicked important.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

charipg (5/7/2015)
Need a script to create a new role in all databases to cover SP creation/execution, any table data manipulation (insert, update, delete & select) .

Google search topics:

"CREATE ROLE site:msdn.microsoft.com"

"GRANT site:msdn.microsoft.com"

"fixed database roles site:msdn.microsoft.com"

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass