Re: HELP - ORACLE SET PASSWORD

Hallo

In article <44pf9g$f28_at_news4.digex.net>, joe_at_access5.digex.net (Joe Nardone) writes:
>Kingaroo (kingaroo_at_aol.com) wrote:
>: > How about
>: > ALTER USER <User's Login> IDENTIFIED BY <NewPassword>?
>: it wont work if 'User' has no DBA privileges.
>It will if they are altering their own account, which I
>believe was the question(?)

I Don't know the OS. Say it is UNIX:

- Have the oracle users a 1 to 1 mapping to os users.
- Set the oracle password to the os password
- If the users only sees your application, invoke the hosts
		change password program somewhere.

This might be a solution.

Groetjes
Corne

-- 
This is MY opinion, not the opinion of my boss nor the company!
C.J.P. Beerse                           | Alcatel Telecom Systems
beerse%nlsun1_at_btmv.bel.alcatel.be       | Postbus 3292
Tel:(+31)70 3079108 Fax:(+31)70 3079191 | NL-2280 GG  Rijswijk