Home > Archive > MS SQL Server > November 2006 > RE: How to hide table columns for users without permission in SQL









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 RE: How to hide table columns for users without permission in SQL
John Bell

2006-11-15, 5:13 am

Hi

Just to add, you may not exclude the user seeing the existance of the column
even if you have denied them permissions to see the data.

John

"John Bell" wrote:
[color=darkred]
> 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:
>
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com