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, 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: [U2] [UV] Run phantom as another user
Windows 2000, tested running routine as another user and works ok, only seems to fail when being run from Redback phantom, even though I have started the redback phantom? Tested from a 'normal' phantom and it works OK. Any thoughts on what's different from RedBack responder to phantom in Unidata? Thanks Graham Forbes Trading Systems BT Consulting & Systems Integration -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lee Beel Sent: 25 January 2005 20:43 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Run phantom as another user If you are on a unix box you should be able to run a cron daemon. Lee >>> [EMAIL PROTECTED] 01/25/05 10:09AM >>> 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/
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/
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" 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/
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: [U2] [UV] Run phantom as another user
One of the possibilites is probably to start shell script , in which you can change UID, start phantom and exit it. Adrian Matthews wrote: 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? We have a situation where we have a background phantom process periodically monitoring a directory on another server. But, when the user that launched the phantom processor changes their password, the file open fails (due to expired credentials). We would like to have the phantom process 'run as' another user account that has the minimum access it needs where the password does not ever expire and create the failed open file problem. We are simply opening the file as a "F" voc pointer with line 2 "\\server\sharename\directory". The universe config parameter ALLOWNFS is set to 1. Thanks! -Troy --- 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/ -- Lembit Pirn 7+7 Software Tondi 1 Tallinn 11313 tel. +372 6566232 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
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? We have a situation where we have a background phantom process periodically monitoring a directory on another server. But, when the user that launched the phantom processor changes their password, the file open fails (due to expired credentials). We would like to have the phantom process 'run as' another user account that has the minimum access it needs where the password does not ever expire and create the failed open file problem. We are simply opening the file as a "F" voc pointer with line 2 "\\server\sharename\directory". The universe config parameter ALLOWNFS is set to 1. Thanks! -Troy --- 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/
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 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: [U2] [UV] Run phantom as another user
ok. Is this unix? and can the command be run from unix? If so, then set it up as a sudo command, and have sudo run it as the other user, I do that for my PORT.STATUS, with UV10, PORT.STATUS only returns your processes unless your root. So I setup a sudo command to run PORT.STATUS as root, and run this command from the command line. 0001: EXECUTE "sh -c 'sudo /usr/mbin/portstatus'" 0002: STOP 0003: END [EMAIL PROTECTED] CBS-BLUE]$ cat /usr/mbin/portstatus cd /usr/uv ; /usr/uv/bin/uv PORT2 [EMAIL PROTECTED] CBS-BLUE]$ cat /etc/sudoers george ALL=(root) NOPASSWD:/usr/mbin/portstatus You can use sudo to also control who can and can't run it as the other user name George >-Original Message- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] Behalf Of >[EMAIL PROTECTED] >Sent: Tuesday, January 25, 2005 4:40 PM >To: u2-users@listserver.u2ug.org >Subject: RE: [U2] [UV] Run phantom as another user > > >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
RE: [U2] [UV] Run phantom as another user
Still curious about BCI. Not up on BCI but if you have Redback that means you are using a web interface. That means you can easily access Oracle and U2 at the same time. Not sure of your app but I'd have an ASP or ASP.NET program that opened U2 and Oracle for all the 2=way data exchanging I wanted. Using ADO, the commands to access both databases would be almost identical. Mike R. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, January 25, 2005 4:40 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Run phantom as another user 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
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/
RE: [U2] [UV] Run phantom as another user
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/
Re: [U2] [UV] Run phantom as another user
You can use the SET.REMOTE.ID command to establish credentials on the remote system for UV/Net. I don't know whether that would work on an NFS mount; I suspect not. If you want to start from the operating system, then it's relatively easy - simply log in as the other user ID and start the phantom, then log out. On UNIX (or with MKS Toolkit or similar) you could even use the su (switch user) command. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Run phantom as another user
Unfortunately UniData does not use the AUTHORIZE statement, but it would probably be a good option to add. It is not a SQL extension, it changes the access rights of the program. So a user who may not have write access to a file, can run a program that can write to the file. Regards David Jordan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baakkonen, Rodney Sent: Wednesday, 26 January 2005 2:47 AM 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? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Run phantom as another user
If you are on a unix box you should be able to run a cron daemon. Lee >>> [EMAIL PROTECTED] 01/25/05 10:09AM >>> 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/
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/
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/
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/
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] [UV] Run phantom as another user
Is there a way to run a phantom process as another user using the PHANTOM command? We have a situation where we have a background phantom process periodically monitoring a directory on another server. But, when the user that launched the phantom processor changes their password, the file open fails (due to expired credentials). We would like to have the phantom process 'run as' another user account that has the minimum access it needs where the password does not ever expire and create the failed open file problem. We are simply opening the file as a "F" voc pointer with line 2 "\\server\sharename\directory". The universe config parameter ALLOWNFS is set to 1. Thanks! -Troy --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/