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 |
|
sql777
Constraint Violating Yak Guru
314 Posts |
 Posted - 2004-10-24 : 16:53:27
|
| Hi,using EM, what should I do to create a user that has full access to 1 database?I want them to have access to EM, Queryanaylzer remotely (server at a ISP).Using EM, there are 2 tabs, Server Roles and Database access, what should I select?TIA |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-10-24 : 17:32:42
|
| Nothing should be checked on Server Admin. Give the login you're creating access to only the one database they need.Enterprise Manager is NOT a good tool for end users, especially if you are trying to keep them out of other databases. |
 |
|
|
sql777
Constraint Violating Yak Guru
314 Posts |
Posted - 2004-10-25 : 02:26:03
|
| but most ISP's give you EM access to their shared sql server database.I basically want to create the same sort of setup for this user account i.e access 1 database, but can do anything on that database via EM or QA. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-10-25 : 04:04:26
|
| give them dbo rights on the database, assign the database as the default db for the user(s), then strip off the public role to it's minimum, i just forgot which objects will prevent users from viewing other databases in EM, but you could check them out, they're automatically included in the public role. remove them one by one and test which one will give you the desired result.--------------------keeping it simple... |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-10-25 : 08:03:58
|
| Consider whether you need to REVOKE permissions to any system SProcs to - xp_cmdshell for exampleOn the shared SQL ISPs that I've used I've been able to see all the other datbases in EM [but not acces them, obviously]Kristen |
|
|
|
|
|
|
|
|
user with full control on 1 db only