Role in SQl server 2008

Question

Post reply

Role in SQl server 2008

sql Anand

SSCommitted

Points: 1597
More actions
October 16, 2011 at 11:42 pm

#250089

hi,
i create 15 reports based on one db..
but i want to give permission to GM to access only 7 reports..Is this possible in role assignment in sql server 2008 deployment

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

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

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 1

15 reports

SSRS? It can be done at any Reporting Tool Administation.

If reports means SQL Scripts / Stored Procedures (I know GM will not dig into database, but in case ;-)) try database roles.

CREATE ROLE (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms187936.aspx

sql Anand SSCommitted Points: 1597 More actions · Answer 2

What is the main use of creating role in sql server 2008

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 3

Thomas.s (10/17/2011)
What is the main use of creating role in sql server 2008

It's set of permissions. With roles you group related permissions and assign it to respective users.

For Example, you have 3 users in database & all of them need access on table ‘A’ for INSERT, UPDATE & DELETE. To achieve this you may give these permissions to individual users ‘X’, ‘Y’ & ‘Z’. So total 9 grant statements (3 users * 3 permissions)

OR

You may create a role. Grant the permissions to this role and then add users to this role. So, 3 permissions assigned to 1 role (3 statements) plus 1 statement for each user to add in the group. Thus Better User Access Management.

Don’t forget to read more on BOL.

sp_addrolemember (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms187750.aspx

GRANT Object Permissions (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms188371.aspx