Hide column - Help newbbie -- sql server new users

Sue Hoegemeier
1/31/2005 5:58:42 PM

You can use column level security but it comes with some
extra considerations, design issues.
You can also set more restricted permissions on the table
and give the users access to a view which does not have the
column in its definition.
Either way, you would want to consider the ramifications if
this is an existing database. What ramifications depend on
your current security setup, ownerships chains, etc.

-Sue

On Mon, 31 Jan 2005 17:50:01 -0600, "Juan Linares"
[quoted text, click to view]

Tom Moreau
1/31/2005 7:54:21 PM

You can grant select to the table and then deny access to the individual
column:

grant select on dbo.MyTable to public
deny select on dbo.MyTable.MySecretColumn to public

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
..
[quoted text, click to view]
Hi everybody, my question is:

is it possible hide a column in my sql table??

i don't want show this column for anybody with access to my server because
contains critical information

Please help me

--
Juan Carlos Linares

Webmaster
Comya Global - Public Relations Network
Communicating Your Agenda Worldwide
www.comyaglobal.com

Tecnología
CB Comunicación S.A de CV.
Tel: 5525-5454
Fax: 5511-0445
Visite nuestro site:
www.cb.com.mx/
www.cb.com.mx/secciones/pressroom

Juan Linares
2/1/2005 11:32:19 AM

it's a good idea, thanks a lot

"Sue Hoegemeier" <Sue_H@nomail.please> escribió en el mensaje
news:7iktv01esp9hn2uboqpj8sf6s9kjoms71r@4ax.com...
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server new users

sql server new users : Hide column - Help newbbie