Re: Deny access to column in table

From: "Vt" <vinu.t.1976@xxxxxxxxxxxxxx>
Date: Sat, 16 Jun 2007 09:59:41 +0100

Hi

Create a view; exclude the column you want to hide in the select statement

Regards

Vt
Knowledge is power;Share it
http://oneplace4sql.blogspot.com

"Marc" <Rombooth@xxxxxxxxxxxxxxxx> wrote in message
news:44CA3762-955B-4EDF-9E4B-3E4E547F85BA@xxxxxxxxxxxxxxxx

Dear all

I would like to give a full select access to a table to all columns it
contains except one that I want to hide

How can I achieve this behavior with sql server 2005 SP2?

Kind regards,

Marc

Prev by Date: Re: permissions required for executing CDOSys stored procedures
Next by Date: Re: Permission at the row level associated with user/login
Previous by thread: RE: Repeated "Login failed for user 'sa'" entries in SQL Server log
Next by thread: Re: Hoe to get Encrypted Password value varbinary field
Index(es):
- Date
- Thread

Relevant Pages

Re: Sending eMails with Win 98 and Win XP not working
... Before complaining I wanted to exclude the possibility of my own mistakes. ... The eMail tool used under Win 95 and Win98 was purchased from ... With kind regards, ...
(microsoft.public.vb.general.discussion)
Re: anaysis tookpak
... That doesn't exclude ... Kind regards, ... if i have 60 focus group candidates, and i do a random sampling of the ...
(microsoft.public.excel.misc)
IMF Filter
... I'm using Exchange 2003 SP2. ... Is there a way to exclude an email address ... from IMF? ...
(microsoft.public.exchange.admin)
IMF Filter exclusions
... I'm using Exchange 2003 SP2. ... Is there a way to exclude an email address ... from IMF? ...
(microsoft.public.exchange.admin)
IMF Question..
... Exchange 2003, SP2 ... How would i exclude an entire domain from block list filter rules? ...
(microsoft.public.exchange.admin)