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.

Report message to a moderator

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: 7065
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 08 18:02:18 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.