Encryption in OLAP

#1

Hi,

I need to encrypt a column of data within my sqlserver database,
however I also require the field to be part of the data set on drill
through, how do I prompt for the user to supply the de-encryption key
in order to display a meaningful data set. I am using Analysis services
as my OLAP tool and SQL Server 2000.

Hope someone can help...

#2

Hi,
You might be able to do it by creating an action within your cube.
ta
Paul

"FigureIT" wrote:

Quote:

Hi,

I need to encrypt a column of data within my sqlserver database,
however I also require the field to be part of the data set on drill
through, how do I prompt for the user to supply the de-encryption key
in order to display a meaningful data set. I am using Analysis services
as my OLAP tool and SQL Server 2000.

Hope someone can help...

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Encryption in OLAP

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Encryption in OLAP - 12-09-2005 , 03:10 AM

RE: Encryption in OLAP - 12-09-2005 , 08:52 AM