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 |
|
melih
Starting Member
7 Posts |
 Posted - 2007-03-26 : 11:52:16
|
| Hi,I need to give a sysadmin role to a user and I need to prevent that user to access some tables in specific databases...thanks in advance... |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
melih
Starting Member
7 Posts |
Posted - 2007-03-26 : 13:03:53
|
| this is a user account created for another company that is going to do some changes on our database.this user needs to be able to create and test the link for our db and their db.giving this user dbo access does not solve the problem. the user needs to be a sysadmin in order to create the link.we are willing to give them sysadmin permission but we do not want them to see some tables in db.I hope it is clear now...Thank you for your time... |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-03-26 : 13:29:40
|
| still doesn't work that way._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2007-03-26 : 13:51:31
|
quote:
Originally posted by melih
this user needs to be able to create and test the link for our db and their db.giving this user dbo access does not solve the problem. the user needs to be a sysadmin in order to create the link.
hmmmm....why would that be? Doesn't make senseBrett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
|
|
|
|
|
|
Deny access for sysadmin