Post reply

Scripting securables in SQL2008R

  • July 7, 2015 at 3:00 am

    #318836

    Is it possible to script out the securables for a database user? I have a user that has specific rights on four objects; two tables and two procedures, however no combinations of the scripting options seem to produce the GRANT etc.

    I actually have to duplicate logins and users (and all dependant objects) for a new domain. e.g.

    copy dom1\john.smith to dom2\john.smith

    Thanks in advance.

    Some screenshots here

  • July 7, 2015 at 3:10 am

    #1810635

    I don't know whether it's possible through the GUI, but you can generate your own scripts from sys.database_permissions. It's a little bit of work for you to do, but once it's done, you can use it again and again.

    John

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

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