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 |
|
laddu
Constraint Violating Yak Guru
332 Posts |
 Posted - 2008-02-18 : 14:19:05
|
| I am new to SQL ServerRecently I installed SQL Server 2005 on one server. And now one User wants to move the databases. What type of permissions can I give to that user on databases? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-18 : 14:26:39
|
| Why you wanna give other user to move database? That is done by DBA's. |
 |
|
|
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2008-02-18 : 14:34:58
|
| Thank you for your speedy reply. Usually what type of permissions a user has on DB? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-18 : 14:40:01
|
| Usually on production Server, We mostly give DB_reader permissions but it depends on criteria for other permissions. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-18 : 20:25:07
|
| User may need exec permission on sps and functions. |
|
|
|
|
|
|
DB access