Can I stop someone changing their password ?

Ok, here is the results of my experimenting :

I created a function which simply raises an application error amd a message saying 'sorry, you cannot change the password'. This was of course, created as per the example I found on MetaLink in a doc entitled 'How do I stop a user changing his password' Oh hum !

I created & compiled this in SYS, as per the 817 docs, on an 8.1.7 Personal Oracle set up - I don't want to screw up a live system just yet !

Next, I created a profile and made it the user in question's default profile. So far so good.

Now, if the user uses ALTER USER to change his password, an error is diosplayed saying that the password verification failed. If he uses PASSWORD, it goes through the motions, and displays my error message from the function.

Unfortunately, or possibly not, the sqlplus session is now totally bolloxed. I cannot type any commands without getting a 'not connected' message. If I try to connect, I get strange error messages seemingly from TNS.

I'm still investigating, but so far, all you can do when the password verification function raises an application error, is exit, and log back in again.

Something for me to ponder as I while away the long hours of the weekend.

Have a nice one people, and thanks again for your suggestions.

Regards, Norman.

Norman Dunbar			EMail:	Norman.Dunbar_at_LFS.co.uk
Database/Unix administrator	Phone:	0113 289 6265
				Fax:	0113 289 3146
Lynx Financial Systems Ltd.	URL:	http://www.Lynx-FS.com


------------------------------------------------------------------------