question

OraLearner avatar image
OraLearner asked

Disabling an account in Oracle

How can we disable a user account in Oracle?

Does locking a user means disable?

oraclelocked
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

·
HillbillyToad avatar image
HillbillyToad answered

Locking an account will prevent someone from logging into the database using that account.

Locking an account won't prevent that schema's objects from being accessed.

3 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

HillbillyToad avatar image HillbillyToad commented ·
REVOKE the appropriate privs (INSERT, UPDATE, DELETE, SELECT) from said users. If said user has a power ROLE like 'DBA', that might not be so easy.
1 Like 1 ·
OraLearner avatar image OraLearner commented ·
Ok. If we want to pervent accessing schema's objects also, how can we do that? Thanks again HillbillyToad.
0 Likes 0 ·
OraLearner avatar image OraLearner commented ·
Thanks for the update HillbillyToad.
0 Likes 0 ·
Tariq Rahiman avatar image
Tariq Rahiman answered

ALTER USER username ACCOUNT LOCK

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.