Locking and unlocking the objects in Oracle
Lock and unlock the objects in oracle. Anyone can unlock and lock the objects, but our requirement it's should be configurable. some admin or some user has control to unlock the objects.
For example, User ABC Locked the EMP tables currently anyone can unlock the objects but it's should either ABC user need to unlock or give some admin user to unlock the objects. We need to some control required to maintain the locking and unlocking the objects and there is no audit info as well.
mek ind shared this idea