This Scripts will check for public access to extended Stored procedures in sql server 2000 and 2005.
2016-12-07
1,055 reads
Mani Singh,
2008-08-08 (first published: 2008-06-16)
This Scripts will check for public access to extended Stored procedures in sql server 2000 and 2005.
Select sysobj.name, user_name(sysperm.grantee) as [Granted to] from master.dbo.sysobjects sysobj join master.dbo.syspermissions sysperm on sysobj.id = sysperm.id where sysobj.type = 'X' order by name
2016-12-07
1,055 reads
2016-01-26
1,422 reads
2007-09-30
1 reads
2007-09-28
5 reads
2007-09-23
2 reads