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 |
|
mdelgado
Posting Yak Master
141 Posts |
 Posted - 2003-01-14 : 10:13:20
|
| Hello all...Can anyone tell me how to hide the tables, queries, stored proc's etc.. in query analyzer when users use a certain login?I tried blocking access to the systables but that didn't work.Any ideas? thanks. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-01-14 : 10:20:12
|
| I don't think you can block users from seeing them in QA, but you can REVOKE or DENY their permissions to SELECT, UPDATE, DELETE or INSERT those tables. |
 |
|
|
|
|
|
Hide Tables in Query Analyzer from a Login