August 19, 2005 at 1:59 pm
I have given dbo permission to one of the user.
Now I want to Revoke select permision for one table and Store procedure. When I do
Revoke SELECT
ON tbl_permision
TO user_dbo
GO
Still the user can able to access tbl_permision table
August 19, 2005 at 2:07 pm
dbo = god >> no restriction, not even checks for restrictions.
August 19, 2005 at 2:13 pm
Revoke just delete any explicit permission you gave to a user. If you wat the user not to access de table you have to use DENY.
If you just added the user to db_owner role and it is not the dabase owner, you can still deny access to the table:
deny SELECT
ON tbl_permision
TO user_dbo
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply