Re: HELP - ORACLE SET PASSWORD

---
In article a12_at_newsbf02.news.aol.com, kingaroo_at_aol.com (Kingaroo) writes:


>> How about

 


>> ALTER USER <User's Login> IDENTIFIED BY <NewPassword>?

>

>it wont work if 'User' has no DBA privileges.


That's funny, I have configured a number of accounts without DBA
privilege and it works just fine for our development staff!


-------------------------------------------------------------------------
-----
Ross Klippert           |
Motorola GSTG           |
Scottsdale, AZ          |
rossk_at_cso.geg.mot.com   |
(602)-441-6794          |
-------------------------------------------------------------------------
-----

In Oracle 7, DBA is no longer a privilege: it is a pre-defined role. The 
DBA role has the system privilege 'ALTER USER', which is the privilege 
needed to change any user's password. 'ALTER USER' privilege can be 
granted individually to any user or role.


Donna Kray
GE Motors & Industrial System
kray.donna_at_mlink.motors.ge.com