Read only access

  • Hello,

    I need to give read only access to employee to specific tables, and I have a problem, I give select on specific table and when i LOG IN, i CAN EDIT REcords, can some one please help me.

    Thank you

  • Generally I give access through defining Roles. You then GRANT SELECT to the Role, not to users. Then you add users to the role.

    If users have more access than you have granted them, then they are already associated with a rôle that has greater access. You must check the setup on that user.

    "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 1 (of 1 total)

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