OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » blocking user

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

blocking user [message #238286]

Thu, 17 May 2007 05:52

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

Report message to a moderator

Re: blocking user [message #238298 is a reply to message #238286]

Thu, 17 May 2007 06:21

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: blocking user [message #238532 is a reply to message #238286]

Fri, 18 May 2007 08:11

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?

Report message to a moderator

Re: blocking user [message #238539 is a reply to message #238532]

Fri, 18 May 2007 08:25

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Previous Topic:	slow truncate in 10.2.0.2
Next Topic:	Database Shuts Down

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 12:35:08 CST 2024