Home » SQL & PL/SQL » SQL & PL/SQL » how to disable one user and how to enable one user.
how to disable one user and how to enable one user. [message #190007] Tue, 29 August 2006 00:36 Go to next message
youthsen
Messages: 45
Registered: August 2006
Member
hi pals

i want ot disable one user and later to enable that user.

pls reply fast.


thanks a lot in advance.
Re: how to disable one user and how to enable one user. [message #190019 is a reply to message #190007] Tue, 29 August 2006 01:16 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
youthsen wrote on Tue, 29 August 2006 07:36

i want ot disable one user and later to enable that user.
Look up the ALTER USER command: "Specify ACCOUNT LOCK to lock the user's account and disable access. Specify ACCOUNT UNLOCK to unlock the user's account and enable access to the account."
Here's one example:
example from the manuals

ALTER USER ashwini ACCOUNT UNLOCK;


youthsen wrote on Tue, 29 August 2006 07:36

pls reply fast.
pls is no member of OraFAQ, so I doubt that he (she?) can reply fast.

MHE
Previous Topic: Cannot use Using Clause with natural Join
Next Topic: Index
Goto Forum:
  


Current Time: Mon Dec 05 13:16:52 CST 2016

Total time taken to generate the page: 0.11505 seconds