Technical Article

public access to extended SP's

,

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

Rate

5 (1)

You rated this post out of 5. Change rating

Share

Share

Rate

5 (1)

You rated this post out of 5. Change rating