"Kamal" <ka****@melstar.com> wrote in message
news:a4**************************@posting.google.c om...
I need to check if any user in the database is assigned any permission
WITH GRANT OPTION. Please let me know how do I check this. Also let me
know if assigning rights WITH GRANT OPTION is possible from enterprise
manager.
Thanks in advance
Kamal
See "sysprotects" in Books Online:
select
object_name(id),
user_name(uid),
user_name(grantor) as 'Granted by'
from
sysprotects
where
protecttype = 204
I don't know about granting that from EM, but since Query Analyzer gives you
better control over TSQL commands, it would probably be better to create a
permissions script which you can then run in many databases.
Simon