I have a development database and I need to syncronize it with several customer databases. Each customer has their own user in the database, however, that user is NOT in my development database.
Right now what I do is Sync the databases, then run a script to grant the correct permissions to all the objects for the user. I have to do this for each customer database. This is very time consuming.
Is there a better way to approach this?
Brien King
brien@classic-soft.com
Right now what I do is Sync the databases, then run a script to grant the correct permissions to all the objects for the user. I have to do this for each customer database. This is very time consuming.
Is there a better way to approach this?
Brien King
brien@classic-soft.com