Post reply

Transfer permissions

  • February 25, 2004 at 10:57 am

    #160498

    SQL 7.0: How do I transfer permissions from a db on server a to a like db on server b?

  • February 25, 2004 at 1:57 pm

    #495672

    I believe you can script this from EM. right click the database, generate scripts and check the permissiosn item.

    Note: the logins and users must already be the same on the new server unless you are using roles.

     

  • February 25, 2004 at 3:45 pm

    #495713

    The users are setp only on server a. Is there a way to copy both the users and permission via a stored procedure?

  • February 26, 2004 at 10:52 am

    #495936

    Going along with Steve's post, if you also check the boxes for 'Script database users and database roles' and 'Script SQL Server logins (Windows and SQL Server logins)', it will create the script for the logins, users, as well as the permissions.

    Here is a link I found to create an SP to transfer logins and passwords between servers.

    http://support.microsoft.com/default.aspx?scid=kb;en-us;246133

    Hope this helps.

    Jarret

  • February 26, 2004 at 3:00 pm

    #496026

    Thanks for the help. I believe this will do the trick.

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

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