Technology Network Community
Oracle Database
Fusion Middleware
Development Tools
Server & Storage Systems
Enterprise Management
Berkeley DB Family
Cloud Computing
Big Data
Business Intelligence
Migration and Modernization
E-Business Suite
PeopleSoft Enterprise
JD Edwards World
JD Edwards EnterpriseOne
User Productivity Kit Pro (UPK) and Tutor
Governance, Risk & Compliance (GRC)
Master Data Management (MDM)
Oracle CRM On Demand
On Demand: SaaS and Managed Applications
AutoVue Enterprise Visualization
Agile PLM
Endeca Experience Management
Fusion Applications
Archived Forums



General Questions

lock accounts 7.3.4

hey  does anyone know if there is possible to lock a database account in oracle 7.3.4 alter user test account lock; doesn't seem to apply.  any ideas would be appricated.

If I recall correctly this was introduced in a subsequent version. But you could of course query the documentation. It is still online at OTN. Probably asked too much.  --  Sybrand Bakker Senior Oracle DBA

The best idea is you lock the whole database and do an upgrade. Not possible, this feature is not supported.  Werner

How about:  alter user lock_him identified by values 'this_account_is_locked';   The only difference is that login attempts will get a password failure message rather than an account is locked message.  Hope that helps,  -Mark

OK thanks everyone.

Hi, this feature is not available into Oracle 7.3.4, please review the next link for more information about this issues.    ALTER USER   Regards.

This feature was first implemented in 9i, so 7.3.4 will report a syntax error.  By the way 7.3.4 is a very old oracle unsupported version, aren't you planning to migrate it to a more recent Oracle Version?  ~  Madrid

Related Links

function change results in performance reduction
problem with capturing of baselines
buggy SQL query?
backup & nid
problem with listener
lsnrctl Linux Error: 111: Connection refused
Getting error while connecting to new user on linux
Oracle 11g listener issue
catbundle_WINBUNDLE_<database SID>_ROLLBACK.sql hangs
Database migration from HP UX to Linux
Backup and Recovery Controlfiles
sql query
How to auto update date column without using trigger
compression feature
Table Space
Exporting only selected rows from a partition