Oninit cdi / Archive
Talk to an expert →

Privilages on Procedures

Posted in 2013

Topics: Stored Procedures & SPL, Security, Permissions & Auditing, Triggers, Constraints & Referential Integrity, Versions, Editions & End-of-Life

Achilleas Achilleos — — source: IIUG Forums & Mailing Lists

Hi to ALL, We have assigned privileges on tables for users .For example (grant select ,update, insert and delete on <table> to <loginUser Name> ) How and what privileges shall we assigned to those users to have the ability to execute stored procedures, functions ,triggers and sequences ????? Just for information our database platform is: IBM Informix Dynamic Server Version 11.50.FC3 Thanks Description: CoopLogo1Description: CoopLogo1 Cooperative Computer Society (S.E.M) Ltd 1306 Nicosia P.O.B. 25037 CY Tel: +357 22 673 901 Fax: +357 22 672 774 Achilleas Achilleos Department Head B' OS and Databases Management <mailto:AchilleasAchilleos@semltd.com.cy> AchilleasAchilleos@semltd.com.cy ____________________________________________________________ The information in this e-mail and any of its attachments is confidential and intended only for the individual to whom it is addressed. If you are not the intended recipient you should immediately notify the sender and delete the message and all of its attachments. Do not copy through any means or use for any reason or reveal its content to anyone. This message cannot be guaranteed to be secure or error-free or delivered on time. The sender bears no responsibility for any virus, loss, disruption or any other damage caused to the sender by the content of this email. This email has been scanned by an antivirus. ____________________________________________________________ --Boundary_(ID_xJQOEmx82rIr9oy1NtzpxA)

↪ replying to Achilleas Achilleos
Fernando Nunes — — source: IIUG Forums & Mailing Lists

On a per procedure base: GRANT EXECUTE ON proc_name TO ...Regards On Mon, Feb 11, 2013 at 7:04 AM, Achilleas Achilleos < AchilleasAchilleos@semltd.com.cy> wrote: > Hi to ALL, > > We have assigned privileges on tables for users .For example (grant select > ,update, insert and delete on <table> to <loginUser Name> ) > > How and what privileges shall we assigned to those users to have the > ability > to execute > > stored procedures, functions ,triggers and sequences ????? > > Just for information our database platform is: IBM Informix Dynamic Server > Version 11.50.FC3 > > Thanks > > Description: CoopLogo1Description: CoopLogo1 > > Cooperative Computer Society (S.E.M) Ltd > > 1306 Nicosia > > P.O.B. 25037 CY > > Tel: +357 22 673 901 > > Fax: +357 22 672 774 > > Achilleas Achilleos > > Department Head B' > > OS and Databases Management > > <mailto:AchilleasAchilleos@semltd.com.cy> AchilleasAchilleos@semltd.com.cy > > ____________________________________________________________ > > The information in this e-mail and any of its attachments is confidential > and intended only for the individual to whom it is addressed. If you are > not the intended recipient you should immediately notify the sender and > delete the message and all of its attachments. Do not copy through > any means or use for any reason or reveal its content to anyone. This > message cannot be guaranteed to be secure or error-free or delivered > on time. The sender bears no responsibility for any virus, loss, disruption > or any other damage caused to the sender by the content of this email. > This email has been scanned by an antivirus. > ____________________________________________________________ > > --Boundary_(ID_xJQOEmx82rIr9oy1NtzpxA) > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --20cf307f37f4e29c4804d5727876

↪ replying to Achilleas Achilleos
Jonathan Leffler — — source: IIUG Forums & Mailing Lists

On Sun, Feb 10, 2013 at 11:04 PM, Achilleas Achilleos < AchilleasAchilleos@semltd.com.cy> wrote: > We have assigned privileges on tables for users .For example (grant > select, update, insert and delete on <table> to <loginUser Name> ) > > How and what privileges shall we assigned to those users to have the > ability > to execute > > stored procedures, functions ,triggers and sequences ????? > > Just for information our database platform is: IBM Informix Dynamic Server > Version 11.50.FC3 > As with all the best answers, 'it depends'. For normal stored procedures, the person running the stored procedure needs execute permission on the stored procedure (and permission to run SPL procedures — GRANT USAGE ON LANGUAGE SPL TO whomever — but that's usually granted already), plus permission to make the accesses that the SPL makes to the tables it uses. For DBA-privileged stored procedures, the owner of the procedure needs the permissions to make the accesses to the table, but the user executing the procedure only needs execute permission on the procedure. -- Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h> Guardian of DBD::Informix - v2013.0118 - http://dbi.perl.org "Blessed are we who can laugh at ourselves, for we shall never cease to be amused." --047d7b62214ce7100c04d5762268