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 |
|
icw
Constraint Violating Yak Guru
378 Posts |
 Posted - 2009-09-17 : 23:52:09
|
| If I user with sysadmin logs on through an ODBC connection, should they be able to see and access all databases and tables regardless of whether they are owned by someone else.E.g. should they be able to access DB1Live.Username.Table1 as well as DB1Live.dbo.Table1 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-09-18 : 00:09:27
|
| Yes. |
 |
|
|
icw
Constraint Violating Yak Guru
378 Posts |
Posted - 2009-09-18 : 00:46:45
|
| Thanks |
|
|
|
|
|
|
Does sysadmin get permissions for everything