MS SQL Server - How to hide table columns for users without permission in SQL Tool

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

How to hide table columns for users without permission in SQL Tool

Wan

2006-11-15, 5:13 am

Hi,
I already set select permission to certain columns in a table for a user.
BUt the user still can view all the columns in the Enterprise Manager/ SQL
Mgt Studio. HOw to hide those columns without permission ?

John Bell

2006-11-15, 5:13 am

Hi

If restrict access to the table by use stored procedures then the user does
not need permissions on the table directly. You can also be granular to
column level what permissions are granted.

Not giving them access to Enterprise Manager may also be an idea.

John

"Wan" wrote:

> Hi,
> I already set select permission to certain columns in a table for a user.
> BUt the user still can view all the columns in the Enterprise Manager/ SQL
> Mgt Studio. HOw to hide those columns without permission ?

Sponsored Links