Solved

Expired Account Set VALID UNTIL

Posted on 2008-06-10
9
1,732 Views
Last Modified: 2013-12-19
I want to have an account that will never expire.  I want to do this without creating a profile.  Looks like the below command works in Oracle 9 but not in Oracle 8.  Any recommendations for an ALTER USER command in Oracle 8 that will give me the option to set an expire date?

ALTER USER test VALID UNTIL 'Jan 31 2340'
OR
ALTER USER test VALID UNTIL 'infinity';
0
Comment
Question by:9413systems
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
9 Comments
 
LVL 29

Expert Comment

by:MikeOM_DBA
ID: 21754020
MIgrate to Oracle 10g.
0
 
LVL 74

Expert Comment

by:sdstuber
ID: 21756228
what is this alter user command?  Are you sure you have the syntax correct?

I looked in the oracle 8, 9 and 10 documentation and also tried running it myself on 8i ,9i,10g and 11g all returned

ORA-00922: missing or invalid option



0
 
LVL 1

Author Comment

by:9413systems
ID: 21762105
The ALTER USER command alters the user.  I use this all the time time unlock accounts set passwords..etc.
0
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 
LVL 74

Expert Comment

by:sdstuber
ID: 21762362
yes, I understand that,
I know what "alter user" is and how to use it.

I don't know what "ALTER USER test VALID UNTIL 'Jan 31 2340'"  is

you said that command works in 9i.
but I wasn't able to run that command nor could I find any supporting documentation that such options exist.

If it does work,  how?  and what does it do?

0
 
LVL 23

Accepted Solution

by:
David earned 500 total points
ID: 22015674
The desired syntax does not exist.  However, to stay in 8i w/o creating a new profile, you have an option to set the default (mandatory) profile as having non-expiring accounts.  NOTE that in order to have accounts with expiring passwords, you must create a new profile and assign those users to that new profile -- which BTW is very, very, simple.

>ALTER PROFILE DEFAULT PASSWORD_LIFE_TIME UNLIMITED;

Reference: http://download.oracle.com/docs/cd/B19306_01/server.102/b14196/users_secure003.htm#sthref432
0
 
LVL 74

Expert Comment

by:sdstuber
ID: 22167149
in the absence of any input from the asker, I think dvz's answer (22015674)  is the best.

It's contrary to what the user asked for, but does in fact solve the problem, especially since there isn't any such syntax as indicated in the question.
0

Featured Post

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and theā€¦
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question