Post reply

database rolls

  • November 14, 2014 at 5:16 am

    #291964

    Hi

    We have created specific database rolls which give different levels of access to the individual tables in the database. Is it possible to script out this granular level of control ?

    The reason being the roll needs setting up onto another server. I am aware I can use the 'generate scripts' option - but this just creates the database roll with the users associated and not the actual granular level of permissions for each table.

    I have also tried using Redgates sql compare - but this just basically does the same as mentioned above.

    Any suggestions ?

  • November 14, 2014 at 6:25 am

    #1758542

    Perry Whittle posted a nice script for scripting all database permissions in this thread;

    I've adapted that one to my own needs:

    the important part there is probably the nested roles, plus the specific grants to the role in your case;

    creating a role that is a member of other roles is something a lot of people neglect.

    http://www.sqlservercentral.com/Forums/Topic1560182-1550-1.aspx

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 2 (of 2 total)

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