[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] Oracle
- Subject: [sqr-users] Oracle
- From: "Smith, Doug" <dsmith@sjfc.edu>
- Date: Wed, 25 Apr 2007 14:27:13 -0400
- Delivery-date: Wed, 25 Apr 2007 14:30:06 -0400
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
- Thread-index: AceHZ45vmvluKovTSs6iOF2ZMR4OMg==
- Thread-topic: Oracle
Good Afternoon,
I noticed that this very same question was posted awhile back, but I
was unable to determine if an answer was posted. If so, then my
apologies and please just point me in the right direction, otherwise my
question is this:
We have instituted a stricter Oracle password policy here at our
institution using Oracle profiles so that users' passwords will expire
every xx number of days. The problem seems to be that during the grace
period when the user's status is listed as "EXPIRED(GRACE)" SQR
programs get the following message error:
(SQR 5528) ORACLE OCISessionBegin(RDBMS) error 28002 in cursor 0:
ORA-28002: the password will expire within 14 days
(SQR 4701) Cannot logon to the database.
The problem of course goes away once they change their password. Bottom
line: is there any way to run SQR programs even when the user's status
is "EXPIRED(GRACE)" ?
Many Thanks,
Doug
Hyperion SQR Server 8.2
Sun 10
Oracle 10g
ERP is Banner 7.x
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users