Post reply

Imposing lock on table level ?

  • May 27, 2008 at 5:53 am

    #191064

    Can updates/inserts be allowed on a single table level (sql 2k) ? As far as we know the rights can be controlled at user/role level....but not sure if a table can be blocked as such for all users.....

    Any line of advice please ?

    Regards

  • May 27, 2008 at 12:36 pm

    #820763

    There is the deny right that overrules allow. If an user is member of a role which has deny update on table X, the user can't update it even when he has permission allow update on table Y with role Z.

    Have to check if it works for administrators. (don't think so)

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

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