OraFAQ Forum: Security » Grant Unlock User

Home » RDBMS Server » Security » Grant Unlock User

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

Grant Unlock User [message #392258]

Tue, 17 March 2009 03:40

Lama
Messages: 45
Registered: February 2006

Member

Dear All,

I need to know the command of granting unlock users pivilege to a user without graning him dba privilege ...

Thanx in advance,
Lama

Report message to a moderator

Re: Grant Unlock User [message #392262 is a reply to message #392258]

Tue, 17 March 2009 03:51

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

Senior Member
Account Moderator

You have to grant him ALTER USER privilege but in this case he can get DBA when he wants.

Regards
Michel

[Updated on: Tue, 17 March 2009 03:51]

Report message to a moderator

Re: Grant Unlock User [message #392279 is a reply to message #392258]

Tue, 17 March 2009 05:09

cookiemonster
Messages: 13973
Registered: September 2008
Location: Rainy Manchester

Senior Member

You could create a procedure that unlocks users under a dba user and then grant execute on that to the user you want.

Report message to a moderator

Re: Grant Unlock User [message #392317 is a reply to message #392258]

Tue, 17 March 2009 06:54

Lama
Messages: 45
Registered: February 2006

Member

thanks for both replies i dont want to grant him dba prev. directely but he actually have the sys password,, so both solutions will work with me

Report message to a moderator

Re: Grant Unlock User [message #392778 is a reply to message #392258]

Thu, 19 March 2009 04:53

alim
Messages: 1
Registered: March 2009

Junior Member

I have the same issue here , and am trying to create a database procedure but i dont know how to run ddl statements inside database procedures ( forms_ddl of course cant be used there )...

can anyone send me the procedure..

Thanks ,
Ali

Report message to a moderator

Re: Grant Unlock User [message #392785 is a reply to message #392778]

Thu, 19 March 2009 05:05

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

>> how to run ddl statements inside database procedures

Use "execute immediate" keyword.

PS: Please don't start new thread.

Report message to a moderator

Previous Topic:	Defining a Oracle User password to never expire
Next Topic:	What roles for creating/modifying users and roles

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 04 01:13:12 CST 2025