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 |
|
nanfa.k@gmail.com
Starting Member
3 Posts |
 Posted - 2007-09-06 : 07:46:34
|
| Hi all,Does anyone know if it's possible secure my sql server so that the tables/views are inaccessible to users logged into the windows?Thanks. |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-09-06 : 14:58:36
|
don't give them the permission to logon...you need to remove the builtin administrator group in your machine and have the services run using your account, but make sure you add your windows account as sysadmin in you sql instancejust my guess on what you really want  --------------------keeping it simple... |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-06 : 23:04:36
|
| If users don't have permission on those objects, they can do nothing. |
|
|
|
|
|
|
Securing SQL Server from logged on windows users