Post reply

Role in SQl server 2008

  • 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

  • October 17, 2011 at 1:26 am

    #1395154

    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

  • October 17, 2011 at 1:37 am

    #1395157

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

  • October 17, 2011 at 2:39 am

    #1395184

    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

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

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