What are the challenges you face when working across database platforms? Take the survey

Question - User Permissions

BrienKingBrienKing Posts: 30 Bronze 3
edited June 6, 2006 1:24PM in SQL Compare Previous Versions
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


This discussion has been closed.