finding privileges of procedure

Posted in 2014

Topics: Data Types & Schema Design, Internationalization & Character Sets, Versions, Editions & End-of-Life

KARL OLIVER — Tue, 06 May 2014 20:31:33 — source: IIUG Forums & Mailing Lists

BM Informix Dynamic Server Version 11.50.FC9 S how do you find privileges of a procedure ? I have looked in SYSPROCEDUREs below procname save_errorlog owner paqis procid 1308 mode O retsize 102 symsize 835 datasize 1482 codesize 164 numargs 6 isproc f specificname externalname paramstyle I langid 2 paramtypes integer,char,varchar,char,char,char variant t client f handlesnulls t iterator f percallcost 0 commutator negator selfunc internal f class stack parallelizable f costfunc selconst 0.00 collation en_US.819

↪ replying to KARL OLIVER

George_Palmer@aotx.uscourts.gov — Tue, 06 May 2014 20:44:55 — source: IIUG Forums & Mailing Lists

sysprocauth From: "KARL OLIVER" <karl.oliver@maf.govt.nz> To: ids@iiug.org, Date: 05/06/2014 03:32 PM Subject: finding privileges of procedure [32945] Sent by: ids-bounces@iiug.org BM Informix Dynamic Server Version 11.50.FC9 S how do you find privileges of a procedure ? I have looked in SYSPROCEDUREs below procname save_errorlog owner paqis procid 1308 mode O retsize 102 symsize 835 datasize 1482 codesize 164 numargs 6 isproc f specificname externalname paramstyle I langid 2 paramtypes integer,char,varchar,char,char,char variant t client f handlesnulls t iterator f percallcost 0 commutator negator selfunc internal f class stack parallelizable f costfunc selconst 0.00 collation en_US.819 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to KARL OLIVER

Art Kagel — Tue, 06 May 2014 20:48:39 — source: IIUG Forums & Mailing Lists

Look in the sysprocauth catalog table. Art Art S. Kagel, Principal Consultant ASK Database Management Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, May 6, 2014 at 4:31 PM, KARL OLIVER <karl.oliver@maf.govt.nz> wrote: > BM Informix Dynamic Server Version 11.50.FC9 S > > how do you find privileges of a procedure ? > I have looked in SYSPROCEDUREs below > > procname save_errorlog > owner paqis > procid 1308 > mode O > retsize 102 > symsize 835 > datasize 1482 > codesize 164 > numargs 6 > isproc f > specificname > externalname > paramstyle I > langid 2 > paramtypes integer,char,varchar,char,char,char > variant t > client f > handlesnulls t > iterator f > percallcost 0 > commutator > negator > selfunc > internal f > class > stack > parallelizable f > costfunc > selconst 0.00 > collation en_US.819 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --047d7bfcf9c21ce3e204f8c15f3c