Re: Priviledges on stored procedure

Posted in 2005

Jonathan Leffler — Fri, 25 Mar 2005 05:51:26 GMT — source: Usenet: comp.databases.informix

Dirk Moolman wrote: > How do I know what the privileges are on a stored procedure? [...] > > If I do a dbschema on the procedure, the priviledges are not shown. > Does it mean I have to do a full database scheme to see this ? The basic information on executability is in sysprocauth - the DBA option information is in sysprocedures (mode column). See the Informix Guide to SQL: Reference manual. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.01 -- http://dbi.perl.org/