Navigation

	Home Page
	Index
	All Pages

Contributor Links

	Create a new Page
	Administration
	File Management
	Login/Logout
	Your Profile

Other Wiki Sections

Software

Granting Execute Rights to Public - SQL Server

select distinct 
    sql = 'grant execute on [' + u.name + '].['  + o.name + '] to public'
from 
    sysobjects o
    inner join sysusers u 
        on o.uid = u.uid
where 1=1
    and o.type in ('FN','P')
    and o.name not like 'dt_%'
order by 1