Thanks Sachnam!

But our security team has rejected the request. They are saying revoke the select permission

[Object:dm_exec_sessions] [Granted To:public] [Database:master]

[Permission:SELECT]

[Object:sysprotects] [Granted To:public] [Database:master]

[Permission:SELECT]

FIx recommendation is

Grant audit file and database...

Hi Lowel,

Somehow I am not able to using homebrew01 script.

Can youplease provide the steps based on my select query. Kind of new to this task. Appriciate your help.

Thanks Lowell.

I got two more requests from user.

In pipe delimited file first line should contain column names, do I need to write manually? or is there any way to do...

I just want to know if few columns are encrypted, script to query the data

table name USER

USERID

USERFNAME

USERLNAME

USERADDRESS

USERPHNUM

USERZIPCODE

USEREMAILID

STATUSID

I have joined recently here as a DBA and new to encryption. The previous only DBA left the organization I got keys to decrypt. Just want to know how to...

only few columns are encrypted.

for example user first name

...

select * from user

I could see encrypted data