Do you mean in the database? If so, both Unix IDs are using the same database ids and passwords. Peter Loo Wolters Kluwer Health (602) 381-9553
-----Original Message----- From: Reidy, Ron [mailto:[EMAIL PROTECTED] Sent: Monday, July 31, 2006 2:34 PM To: Loo, Peter # PHX; DBI-Users Subject: RE: Invalid authorization specification (SQL-28000) Permissions on something? -----Original Message----- From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED] Sent: Monday, July 31, 2006 3:20 PM To: DBI-Users Subject: Invalid authorization specification (SQL-28000) Hi All, I don't know what is causing the following error, but I can successfully complete the program as one user and not as another. Logging into the same database with the same user id and password. This is very strange. The .profile on both ids are also the same. Would someone know what might be causing this? Has someone experienced this before? DBI connect('testdb','testuser',...) failed: [unixODBC]Invalid authorization specification (SQL-28000)(DBD: db_login/SQLConnect err=-1) at /usr/local/apps/common/override/bin/GlobalRoutines.pm line 51 Peter Loo This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system. This E-mail message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply E-mail, and destroy all copies of the original message.