RE: [sqr-users] Oracle

["Prasanna Menta" <PMenta@umuc.edu>]

Why would you want to do this? Initially you are trying to control
password policies and by-passing the policies. 
Status of Expired will not have resources at the DB level, if this is
changed it is a global change (my thoughts ....).
Hope this helps


-----Original Message-----
From: sqr-users-bounces+pmenta=umuc.edu@sqrug.org
[mailto:sqr-users-bounces+pmenta=umuc.edu@sqrug.org] On Behalf Of Smith,
Doug
Sent: Wednesday, April 25, 2007 2:27 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] 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

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users