report of which logins have what previledge...

25112
25112 used Ask the Experts™
on
We give several layers of permissions for different domain groups.. like the below..

GRANT ALTER, EXECUTE, SELECT, INSERT, UPDATE, DELETE ON SCHEMA ::dbo TO [DomainGroup]
GRANT CREATE PROCEDURE TO [DomainGroup]
GRANT CREATE FUNCTION TO [DomainGroup]
GRANT CREATE VIEW TO [DomainGroup]
DENY CREATE TABLE TO [DomainGroup]

at the end of the day, what kind of query will help to bring a report of which logins have CREATE PROCEDURE and who all have ALTER / EXECUTE etc.

can you guide which system views will help to bring the report together..

thanks...
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
ValentinoVBI Consultant
Most Valuable Expert 2011
Commented:
There are several sys tables/views which you'll need to use.  Have a look at the following article by Tim Chapman: http://www.techrepublic.com/blog/datacenter/reviewing-sql-server-permissions/466

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial