Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: CHANGE PASSWORD
Miguel Almeida wrote:
>
> How can i prevent a user, with ALTER USER system privilege, to change SYS
> password?
We had the need for certain end-users ("application owners") to be able to setup users for their own apps and reset passwords etc...We overcame the problem above by using queues...
end-user submits a request to the queue (to create an account or reset a password etc)..The queue listener (which runs with under SYS or something similar) then processes the request and does things like validation checking etc etc and then proceeds with the request (or emails them an error)...
Took a while to setup but seems to work ok now...
HTH
--