Post reply

Restore Permission for tables/fields

  • December 16, 2009 at 7:32 am

    #218740

    Does anyone knows how to restore the existing permission that has set for each table? I need to restore the existing permission I have set earlier in my previous database into my newly created database.

    E.g. Table 1 has 5 fields and User A is only able to see 2 of the 5 fields.

    Please advise. Thanks.

  • December 16, 2009 at 8:46 am

    #1093060

    In order to prevent a user from seeing only certain columns, you'll need to either limit the users access through a view or a stored procedure. If you give them read access to the table, they'll be able to see all columns.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 2 posts - 1 through 2 (of 2 total)

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