Priviledges on stored procedure

[Dirk Moolman]

How do I know what the priviledges are on a stored procedure ? I read
this bit in the manual:


DBA Option

If you create a procedure using the DBA option, it is known as a
DBAprivileged procedure. If you do not use the DBA option, the procedure
is
known as an owner-privileged procedure. The privileges associated with
the
execution of a procedure are determined by whether the procedure is
created
with the DBA keyword. See Chapter 12 of the Informix Guide to SQL:
Tutorial
for more information.

If you create an owner-privileged procedure in a database that is not
ANSI-compliant, the NODEFDAC environment variable prevents privileges
on that procedure from being granted to PUBLIC. See the Informix Guide
to
SQL: Reference for further information on the NODEFDAC environment
variable.



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 ?


Dirk

sending to informix-list

[Jonathan Leffler]

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.