How to reoke permissions on a particular Role

  • Hi All,

    I have a user role,for that role having full permission. That role is using in all the databases in my server. Now I want to remove only some permission for that role. Can Any one please help me out in this..

    Thanks in Advance..

  • What do you mean "full permission"?

    You can remove permission from role using REVOKE

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

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

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