RE: Unclassified RE: [U2] [UV] Run phantom as another user
Thanks, LeRoy, I _knew_ I'd seen it somewhere. Pity this 10.0 improvement isn't mentioned in the 10.1 documentation. Any chance of it being in the 10.1A docco, or will we have to wait for 11.x? Or can it be at least mentioned in the 10.1 patch list / release notes for the time being? Regards Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Leroy Dreyfuss Sent: Thursday, 27 January 2005 17:41 To: u2-users@listserver.u2ug.org Subject: Re: Unclassified RE: [U2] [UV] Run phantom as another user From the UV 10.0.19 patchlist file: Issue Short Description - - 3766 In order to run a phantom process as a different user, an enhancement has been made to the PHANTOM command. The syntax is as follows: PHANTOM [BRIEF] [SQUAWK] command -U username [password] When you are logged in as root, you can specify -U and the username to run the phantom process as a different user. On Windows platforms, you must also specify the password for the username. Regards, LeRoy F. Dreyfuss Product Manager IBM UniVerse and UniData (U2) Extended Relational Databases IBM DB2 Information Management Software Tel: 303-672-1254 Fax: 303-294-4832 Mobile: 720-341-4317 Tie-line: 770-1254 External email: [EMAIL PROTECTED] The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: Unclassified RE: [U2] [UV] Run phantom as another user
Or even adding it to the HELP PHANTOM output would be nice -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of HENDERSON MIKE, MR Sent: 30 January 2005 19:23 To: u2-users@listserver.u2ug.org Subject: RE: Unclassified RE: [U2] [UV] Run phantom as another user Thanks, LeRoy, I _knew_ I'd seen it somewhere. Pity this 10.0 improvement isn't mentioned in the 10.1 documentation. Any chance of it being in the 10.1A docco, or will we have to wait for 11.x? Or can it be at least mentioned in the 10.1 patch list / release notes for the time being? Regards Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Leroy Dreyfuss Sent: Thursday, 27 January 2005 17:41 To: u2-users@listserver.u2ug.org Subject: Re: Unclassified RE: [U2] [UV] Run phantom as another user From the UV 10.0.19 patchlist file: Issue Short Description - - 3766 In order to run a phantom process as a different user, an enhancement has been made to the PHANTOM command. The syntax is as follows: PHANTOM [BRIEF] [SQUAWK] command -U username [password] When you are logged in as root, you can specify -U and the username to run the phantom process as a different user. On Windows platforms, you must also specify the password for the username. Regards, LeRoy F. Dreyfuss Product Manager IBM UniVerse and UniData (U2) Extended Relational Databases IBM DB2 Information Management Software Tel: 303-672-1254 Fax: 303-294-4832 Mobile: 720-341-4317 Tie-line: 770-1254 External email: [EMAIL PROTECTED] The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: Unclassified RE: [U2] [UV] Run phantom as another user
Thanks Mike and David, found out the problem only happens when I call from RedBack. Oracle is running on Unix and I have the connection user name and password embedded in my Unidata code. Not sure why it doesn't work from RedBack responder, but got around problem by have a batch file which runs the routine. Thanks for your help, Graham Graham Forbes Trading Systems BT Consulting Systems Integration -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of HENDERSON MIKE, MR Sent: 25 January 2005 22:41 To: u2-users@listserver.u2ug.org Subject: Unclassified RE: [U2] [UV] Run phantom as another user Graham, For David's very good idea to work, you must not be using NT Authentication for the ODBC Connection that the BCI is using. [You did not say what O/S the Oracle host is running]. If the Oracle host is a Windows box, and the ODBC connection is using NT Authentication, it will ignore whatever UID Password you pass in, and use the credentials of the user issuing the request. If you are not using NT Authentication, I suggest you should use the UniBasic encryption / decryption functions to store the password encrypted on disk, not in plain text in the code of the program [apologies if 'teaching Grandma to suck eggs']. Note that you can run a SQL Stored Procedure [via SQLExecuteDirect rather than SQLExecute], which might enable you to do all you want. HTH Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Jordan Sent: Wednesday, 26 January 2005 10:44 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Run phantom as another user You can make an SQL call to a subroutine on a remote server. You can set the SQL Connect statement with a different user name and password. Bind the Parameters for the Subroutine and then Call it. The code below may give you some idea. Regards David Jordan 0019: UID = USERNAME 0020: PWD = PASSWORD 0021: SOURCE = FCSHOST 0022: PRINT Connecting to Computer: : 0023: Fn = SQLConnect ... 0027: STATUS = SQLSetConnectOption(CONENV, SQL.OS.UID, UID) 0028: STATUS = SQLSetConnectOption(CONENV, SQL.OS.PWD, PWD) 0029: PRINT Connecting to data source: : SOURCE 0030: STATUS = SQLConnect(CONENV,SOURCE,PATHNAME,) 0042: Fn = SQLBindParameter 0043: *status = SQLBindParameter (statement.env, mrk#, data.type, sql.type, prec, scale,param [,param.type]) 0044: STATUS = SQLBindParameter(STMTENV,1,SQL.B.BASIC,SQL.CHAR,0,0,CLIENT.NO,SQL.PARAM. INPU T) 0045: GOSUB CKSTMTENV .. 0055: STATUS = SQLExecute(STMTENV) 0056:IF STATUS SQL.SUCCESS THEN RETURN 0 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, 26 January 2005 5:10 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Run phantom as another user Anyone know how to run a Unidata subroutine as someone else? I cannot find the article in u2ug. Thanks Graham --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy ord istribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. --- 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/
Unclassified RE: [U2] [UV] Run phantom as another user
Oh good, it's not just me! I too remember something coming out about it being a new feature (in 10.1 I think), but I can't find anything in my IBM or U2UG archives about it either now. Have the IBM people stopped lurking on this list? I'd have expected them to come back on this by now. Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Adrian Matthews Sent: Wednesday, 26 January 2005 21:11 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Run phantom as another user I can't seem to find it now but I'm sure I read in the release notes for one of the new releases that a user name can be specified at the command line when launching a phantom now. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Buss, Troy (Logitek Systems) Sent: 25 January 2005 02:20 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? [snip] The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: Unclassified RE: [U2] [UV] Run phantom as another user
From the UV 10.0.19 patchlist file: Issue Short Description - - 3766 In order to run a phantom process as a different user, an enhancement has been made to the PHANTOM command. The syntax is as follows: PHANTOM [BRIEF] [SQUAWK] command -U username [password] When you are logged in as root, you can specify -U and the username to run the phantom process as a different user. On Windows platforms, you must also specify the password for the username. Regards, LeRoy F. Dreyfuss Product Manager IBM UniVerse and UniData (U2) Extended Relational Databases IBM DB2 Information Management Software Tel: 303-672-1254 Fax: 303-294-4832 Mobile: 720-341-4317 Tie-line: 770-1254 External email: [EMAIL PROTECTED] WWW: http://www.ibm.com/software/data/u2 HENDERSON MIKE, MR MICHAEL.HENDERSO To [EMAIL PROTECTED]u2-users@listserver.u2ug.org Sent by: cc [EMAIL PROTECTED] stserver.u2ug.org Subject Unclassified RE: [U2] [UV] Run phantom as another user 01/26/2005 11:18 AM Please respond to [EMAIL PROTECTED] er.u2ug.org Oh good, it's not just me! I too remember something coming out about it being a new feature (in 10.1 I think), but I can't find anything in my IBM or U2UG archives about it either now. Have the IBM people stopped lurking on this list? I'd have expected them to come back on this by now. Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Adrian Matthews Sent: Wednesday, 26 January 2005 21:11 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Run phantom as another user I can't seem to find it now but I'm sure I read in the release notes for one of the new releases that a user name can be specified at the command line when launching a phantom now. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Buss, Troy (Logitek Systems) Sent: 25 January 2005 02:20 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? [snip] The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type image/gif which had a name of graycol.gif] [demime 1.01d removed an attachment of type image/gif which had a name of pic02833.gif] [demime 1.01d removed an attachment of type image/gif which had a name of ecblank.gif] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/