Post reply

master key (encryption)

  • December 10, 2008 at 6:28 am

    #94279

    Hi,

    Is there any table or dynamic managed view providing information

    about the master key using sa account.

  • December 10, 2008 at 6:31 am

    #910285

    What info are you looking for?

    Try this:

    select * from sys.symmetric_keys

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 10, 2008 at 9:09 am

    #910460

    Thanks Gail

    I am also stuck up in creating a audit table where any delete,

    update to the column where encryption has been done.The audit

    table should contain the log.

    Prasanna.

  • December 10, 2008 at 9:23 am

    #910475

    you should be able to use a trigger to log this information and the data should be available in there.

    However, be sure you log the encrypted text or you are somewhat defeating the purpose of the encryption.

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

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