Security Roles and Security Task Listing

Security Roles and Security Task Listing

This scripts lists all security roles and related security tasks.

SELECT     	dbo.SY10700.SECURITYTASKID, 
		dbo.SY09400.DSPLNAME, 
		dbo.SY09400.TYPESTR, 
		dbo.SY10600.SECURITYROLEID, 
		dbo.SY09400.SERIES
FROM         	dbo.SY09400 INNER JOIN
        	dbo.SY10700 ON 
		dbo.SY09400.DICTID = dbo.SY10700.DICTID AND 
		dbo.SY09400.SECRESTYPE = dbo.SY10700.SECRESTYPE AND 
                dbo.SY09400.SECURITYID = dbo.SY10700.SECURITYID 
INNER JOIN      dbo.SY10600 ON 
		dbo.SY10700.SECURITYTASKID = dbo.SY10600.SECURITYTASKID

Cheers!
Sanjay