CREATEprocJMO_WBR_Self( @k_wbr_stidchar(21) ) as begin Select wbr_stid, wbr_groupid, wbr_node, wbr_type, wbr_timz, wbr_dsc Fromjmo_wbr Where wbr_stid=@k_wbr_stid Orderby wbr_stid end GO GRANTEXECUTEON[dbo].[JMO_WBR_Self]TO[emadmin] GRANTEXECUTEON[dbo].[JMO_WBR_Self]TO[jmoadmin] GRANTEXECUTEON[dbo].[JMO_WBR_Self]TO[uniadmin] GO