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 |
|
pmccann1
Posting Yak Master
107 Posts |
 Posted - 2007-03-06 : 10:23:32
|
| is there a way of locking db on server. i am doing a overtime and pay system but there is a few members of IT staff that are very nosey and this is senstive information and i dont want them looking at the tables on the server can these be locked for only me to view |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-03-06 : 11:01:44
|
| That's what permissions are for. If they are sysadmins you aren't going to be able to keep them out with permissions though. |
 |
|
|
pmccann1
Posting Yak Master
107 Posts |
Posted - 2007-03-06 : 11:31:06
|
| they have full access to the server |
|
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-03-06 : 11:33:33
|
| So in that case, they can go around anything you set. If you want to keep someone out, by definition they cannot have full access. |
|
|
|
|
|
|
Locking cb on server