Blog Pages

Remove permissions of table from user

REVOKE DELETE ON TABLENAME FROM sss

Notes:
  • Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself.
  • The user could have implicit rights through a stored procedure, so setting only the permissions at table level could not be enough.

No comments:

Post a Comment