April 11, 2005 at 1:14 am
Hi all,
Currently we have our SQL Server database in a central server which is used for developement. All the developers are currently using the Database for developement through same login and password.
Since our team size is growing we want to allow only specific permissions and operations to the developers. We created some roles and assigned only certain permissions to the roles, created a group for the developers and assigned this role to the developer so that they can use only specific permissions.
When creating the Database objects we had to append "Domain\DatabaseName\Role" to the objects. Since we already finished the project and since it is a product, in this method we need to modify all the files where the DB objects are used. which is a time consuming process.
is there anyother way we can do this???? any workaround.
thanks for the help.
sathya
April 11, 2005 at 7:26 am
If you need to modify the files themselves, you may try to find a way to map your Domain / Database Name / Role into what they should be in the finished product. Put that in a database table or something of that sort, then use a script with regular expressions to find and replace. If you can create some sort of process like this, it should be faster than doing it by hand if you have a large number of scripts to modify.
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply