How to Inactivate the Oracle User?

[Praveen]

Hi All,

I Created a Oracle user(schema) in my database. Now instead of droping
the oracle user(schema), i want to inactivate it.

Can anyone tell me how to inactivate the user instead of droping it?

Thanks in Advance,
Praveen

[LKBrwn_DBA]

Try:

ALTER USER THE_USER ACCOUNT LOCK;

--
Posted via http://dbforums.com

[Daniel Roy]

"alter user ... account lock"

Daniel

[Michael Kuznetsov]

Hi Praveen,

use this command:

alter user <user name> account lock
/

Regards,
Michael
Brainbench MVP for Oracle Programming
http://www.brainbench.com
sp**********@yahoo.com (Praveen) wrote in message news:<98**************************@posting.google. com>...

Hi All,

I Created a Oracle user(schema) in my database. Now instead of droping
the oracle user(schema), i want to inactivate it.

Can anyone tell me how to inactivate the user instead of droping it?

Thanks in Advance,
Praveen

[Irfan Bondre]

You can revoke his create session priviledge, in that case he won't be
able to login. Thus inactivated. But all his objects will still be
available.

ibondre
sp**********@yahoo.com (Praveen) wrote in message news:<98**************************@posting.google. com>...

Hi All,

I Created a Oracle user(schema) in my database. Now instead of droping
the oracle user(schema), i want to inactivate it.

Can anyone tell me how to inactivate the user instead of droping it?

Thanks in Advance,
Praveen

[michael ngong]

sp**********@yahoo.com (Praveen) wrote in message news:<98**************************@posting.google. com>...

Hi All,

I Created a Oracle user(schema) in my database. Now instead of droping
the oracle user(schema), i want to inactivate it.

Can anyone tell me how to inactivate the user instead of droping it?

Thanks in Advance,
Praveen

alter user mike account lock (Locks out the user)

alter user mike account unlock (opens up mike)
That should keep out a user

Michael Tubuo Ngong

[Praveen]

Hi All,

Thanks to everyone for the responses.
Yes, atlast i used the samething...

alter user the_user lock/unlock;

Thanks,
Praveen

mn****@yahoo.com (michael ngong) wrote in message news:<ec**************************@posting.google. com>...

sp**********@yahoo.com (Praveen) wrote in message news:<98**************************@posting.google. com>...

Hi All,

I Created a Oracle user(schema) in my database. Now instead of droping
the oracle user(schema), i want to inactivate it.

Can anyone tell me how to inactivate the user instead of droping it?

Thanks in Advance,
Praveen

alter user mike account lock (Locks out the user)

alter user mike account unlock (opens up mike)
That should keep out a user

Michael Tubuo Ngong