-- текст
 
select seqno, data
from sysprocbody b inner join sysprocedures p on p.procid == b.procid
where b.datakey ==  "T"  and p.procname ==  "<your_procedure_name>" 
order by seqno

 -- права
 
select grantee, procauth from
sysprocauth a inner join sysprocedures p on p.procid == a.procid
where p.procname ==  "<your_procedure_name>"