How to Encrypt a Table

  • Deal all,

    I have table in my Database to inset audit Trail Data from Application. I want to Encrypt this Table so that any other user would not be able to see its data.

    I just want to encrypt only one table and another security wrapper over the table.

    What should I do to acheive this goal in MSSQL 2008R2.Please refer me any tutorial or suggest me its solution.

    Thanks

  • hi!

    You may use this step by step guide by PINAL. Im pretty sure this procedure is the same as the one when we did encryption thingy in our MS SQL Server 2008 training. 🙂 just follow his guide!

    link below. 🙂

    [/url]

    ===============================================================

    "lets do amazing" our company motto..

  • Thanks

    It works for me.

  • cheers! 🙂

    ===============================================================

    "lets do amazing" our company motto..

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

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