Sorry, should have said I am using BCI Connect & SQL to extract data from an Oracle database into Unidata. Works as me, but not when executed from a RedBack phantom which has been started by someone else.
Graham Forbes Trading Systems BT Consulting & Systems Integration -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Randall Sent: 25 January 2005 18:24 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Run phantom as another user Why not GRANT the other user access to whatever it is? And if you are using Redback, why do you need SQL anyway? ADO? Mike R. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, January 25, 2005 1:10 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Run phantom as another user I think I have this problem as well. I have a SQL command which works when I run it, but when my RedBack phantom run's it it fails with : Error text is [Ardent][SQL Client][ODBC][Microsoft][ODBC Driver Manager] Co nnection not open Anyone know how to run a Unidata subroutine as someone else? I cannot find the article in u2ug. Thanks Graham Graham Forbes Trading Systems BT Consulting & Systems Integration -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baakkonen, Rodney Sent: 25 January 2005 15:47 To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] [UV] Run phantom as another user I am looking at this AUTHORIZE statement in Unidata. I am not able to compile a program using it and cannot find anything in the manuals about it. Is this a Universe sql only extension to Basic? -----Original Message----- From: David Jordan [mailto:[EMAIL PROTECTED] Sent: Monday, January 24, 2005 10:33 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Run phantom as another user In a BASIC program you can use the AUTHORIZE statement to set a different security credential. (See the U2UG newsletter on the U2UG web site for the article of security) You set the statement to AUTHORIZE username Then compile the program as that user. Anyone running that program will run under that usernames credentials. Regards David Jordan -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Buss, Troy (Logitek Systems) Sent: Tuesday, 25 January 2005 1:20 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Run phantom as another user Is there a way to run a phantom process as another user using the PHANTOM command? ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ******************************************************************** This email may contain information which is privileged or confidential. If you are not the intended recipient of this email, please notify the sender immediately and delete it without reading, copying, storing, forwarding or disclosing its contents to any other person Thank you Check us out at http://www.bt.com/consulting ******************************************************************** ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ******************************************************************** This email may contain information which is privileged or confidential. If you are not the intended recipient of this email, please notify the sender immediately and delete it without reading, copying, storing, forwarding or disclosing its contents to any other person Thank you Check us out at http://www.bt.com/consulting ******************************************************************** ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/