How to mask a field?

Question

How to mask a field?

shivashankara9

SSC Eights!

Points: 809
More actions
August 19, 2012 at 6:08 pm

#280022

Hi,
I have a table with 10 columns
Out of 10, i need to mask 5 columns because i don't want to show those columns in development and testing environment.
If any of you have solution for this please let me know!!
I am working on SQL Server 2008.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

demonfox SSCertifiable Points: 6289 More actions · Answer 1

shivashankara9 (8/19/2012)
Hi,
I have a table with 10 columns
Out of 10, i need to mask 5 columns because i don't want to show those columns in development and testing environment.

when you say mask , you mean only five columns are visible in a select query , is it ?

I am not sure how to hide the columns in sql server ; it's a feature in excel . But, you may consider creating a view.

~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:

shivashankara9 SSC Eights! Points: 809 More actions · Answer 2

demonfox (8/19/2012)
shivashankara9 (8/19/2012)
Hi,
I have a table with 10 columns
Out of 10, i need to mask 5 columns because i don't want to show those columns in development and testing environment.
when you say mask , you mean only five columns are visible in a select query , is it ?
I am not sure how to hide the columns in sql server ; it's a feature in excel . But, you may consider creating a view.

yes, 5 columns should visible

as, you said we can do with view

please let me know, how to do with view.

demonfox SSCertifiable Points: 6289 More actions · Answer 3

shivashankara9 (8/19/2012)
yes, 5 columns should visible
as, you said we can do with view
please let me know, how to do with view.

create a view with visible columns ; have permission set up for the inherent table according to role and requirement. create a new role, if you have to.

Check out the syntax @msdn.

~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:

AbbeyR SSC Enthusiast Points: 145 More actions · Answer 4

In its simplest form

CREATE VIEW <ViewName> AS

SELECT Col1, Col2 etc

FROM <TableName>