Fwd: help with role not working ??
Posted in 2008
Topics: Stored Procedures & SPL, Security, Permissions & Auditing
Could it be execute privs on the script or task you are trying to SYSTEM out to? Art On Thu, Jun 19, 2008 at 1:00 PM, Floyd Wellershaus <floyd@fwellers.com> wrote: > We have a role called r_webusr. > That role has execute permissions to a stored procedure called wdv_match. > > If I log into a sql session as myself, set the role to r_webusr, check to > ensure the role is set, and execute the procedure I get a 668 error, ( > cannot execute system command) > > btw, the procedure is using the system command to call a shell script. > > This is working in production, but not in dev any longer. > It works when I run it as the owner of the procedure, but not as the role. > > Any ideas would be appreciated. > > thanks, > floyd > ps. > ids10.0.FC5 on Aix5.3. > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.