Post reply

Hiding column information

  • September 25, 2008 at 9:27 am

    #124815

    Hi,

    Here is my scenario.

    create table dbo.customer_info(Customer_ID bigint, SSN varchar(32))

    insert into dbo.customer_info values(2330, '543-54-9087')

    insert into dbo.customer_info values(2330, '321-54-9087')

    Is there any way that a DBA can hide SSN information from users/database users.

    Not through the views/functions/procedures

    Thanks you for your valuable time.

    Sri.

  • September 25, 2008 at 9:31 am

    #877101

    Are you talking about preventing normal users access to viewing the table structure (columns etc.)?

  • September 25, 2008 at 12:02 pm

    #877243

    Sort of...

    Here the user should able to see the column (SSN) but the data should be hidden.

    It that possible ?

    Sri.

  • September 25, 2008 at 12:08 pm

    #877249

    Search BOL for encryption.

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

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