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 |
|
pras2007
Posting Yak Master
216 Posts |
 Posted - 2008-12-21 : 23:39:42
|
| Hello All,Is it possible for a user to only be able to access one database on a particular server? I just created a user account that suppose to only have access to one table, but when I login as that user, I was able to access all the databases on that server. Does anybody know how to setup a user account that only have access to one database instead the entire database in the server? Furthermore that user account should be able to create tables inside the assigned database. Please advice. Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
pras2007
Posting Yak Master
216 Posts |
Posted - 2008-12-22 : 19:18:54
|
| Thanks for the response tkizer,the following is what was granted to this user:Server Roles SysadminUser Mapping Users mapped to this login One table is checked Database role membership for: AdventurWorks PublicPlease advice me on how to limit this user to one table only. Thanks |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-22 : 19:31:20
|
| You have remove user from sysadmin.with sysadmin,user can perform any actions.Read Booksonline about server role,database roles,object-level permission. |
|
|
|
pras2007
Posting Yak Master
216 Posts |
Posted - 2008-12-22 : 19:39:36
|
| Thanks for the response sodeep, I recreated the user access not to include sysadmin role and it works!Thanks. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Users access levels