Question - User Permissions
BrienKing
Posts: 30 Bronze 3
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
This discussion has been closed.
Comments
We may think about this for the future. A work around could be to implement role based security.
Hope that helps.
David Connell