Home » RDBMS Server » Security » Grant Unlock User
Grant Unlock User [message #392258] Tue, 17 March 2009 03:40 Go to next message
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
Re: Grant Unlock User [message #392262 is a reply to message #392258] Tue, 17 March 2009 03:51 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
cookiemonster
Messages: 13917
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.
Re: Grant Unlock User [message #392317 is a reply to message #392258] Tue, 17 March 2009 06:54 Go to previous messageGo to next message
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
Re: Grant Unlock User [message #392778 is a reply to message #392258] Thu, 19 March 2009 04:53 Go to previous messageGo to next message
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
Re: Grant Unlock User [message #392785 is a reply to message #392778] Thu, 19 March 2009 05:05 Go to previous message
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.
Previous Topic: Defining a Oracle User password to never expire
Next Topic: What roles for creating/modifying users and roles
Goto Forum:
  


Current Time: Fri Mar 29 06:17:42 CDT 2024