revoke grant access for specific user

i want to ask how to revoke grant access to specific user, so the spesific user can give grant access to other user.

thank in advance

I'm not exactly sure what you're asking for here, but i'll take a guess:

Have a look at the fixed database roles db_securityadmin and db_accessadmin which manage permissions/db access in BOL.

Also check the GRANT and REVOKE statements which may help.

If i've misundertood your intentions, could you please elaborate?

HTH!

|||

If you provided a user permissions to also GRANT permission on the object(s) using the WITH GRANT option, you can remove just the ability to grant permissions to others.

REVOKE GRANT OPTION ON OBJECT::ObjectName FROM User