Home » RDBMS Server » Server Administration » blocking user
blocking user [message #238286] Thu, 17 May 2007 05:52 Go to next message
mymailbox.21
Messages: 14
Registered: May 2007
Location: hyderabad
Junior Member
hi all,

i am newbie to orafaq forum & working as DBA.

i want to know how to block a user from changing his own password.

thanks in advance
pavan
Re: blocking user [message #238298 is a reply to message #238286] Thu, 17 May 2007 06:21 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Either:
- create a DDL trigger to check if an alter user is done and forbid it
- create a password verification function that returns always FALSE and associate it to the user profile.

Each underlined word can be searched in Oracle documentation: http://www.oracle.com/pls/db102/db102.federated_search

Regards
Michel
Re: blocking user [message #238532 is a reply to message #238286] Fri, 18 May 2007 08:11 Go to previous messageGo to next message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
I'm curious as to why you don't want to let a user change their password?
Re: blocking user [message #238539 is a reply to message #238532] Fri, 18 May 2007 08:25 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
That's a good question.
We, unlike the OP, force our users to change their password at least every 2 months.
But there are some (bad) softwares that require hard coded passwords in configuration files and don't support we change them.

Regards
Michel
Previous Topic: slow truncate in 10.2.0.2
Next Topic: Database Shuts Down
Goto Forum:
  


Current Time: Thu Dec 08 20:09:49 CST 2016

Total time taken to generate the page: 0.07963 seconds