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 |
|
m_saad
Starting Member
22 Posts |
 Posted - 2005-08-09 : 08:18:27
|
| I wish to lock down access of a particular user on all user and system tables and just allow him/her to access one single view, is this possible and if yes then how?Thanks in Advance. |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-08-09 : 10:54:33
|
| read about GRANT, DENY, and REVOKE.====================================================Regards,Sean RoussyGENERAL ADVICE FOR EVERYONE: Please backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own. |
 |
|
|
|
|
|
Lock down access