Hi, Thanks for the tip. One observation though: For revoke, shouldn't it be REVOKE instead of GRANT? Thanks.
Yes it was typo mistake and it should be ---revoke the access REVOKE SELECT, INSERT, UPDATE, DELETE ON DATABASE::master TO [domain\username] ---change db name from master to your own db name if needed
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply