Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gsmoorthy
Starting Member
4 Posts |
 Posted - 2005-04-11 : 03:33:54
|
| 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 |
|
|
jason
Posting Yak Master
164 Posts |
Posted - 2005-04-11 : 12:07:36
|
| You might be able to use sp_changedbowner to change the object owner to 'dbo', but it will depend on your circumstances. At the same time, give the appropriate permissions to the old owner so that they can continue to work witht the object as needed. |
 |
|
|
|
|
|
Help on SQL Server Roles and Permissions