Solved

Expired Account Set VALID UNTIL

Posted on 2008-06-10
9
1,724 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
9 Comments
 
LVL 29

Expert Comment

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

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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 73

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 73

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
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.

895 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now