Hi DBAs,
Can somebody tell me how to find whether a particular schema is being used or not in a oracle database.
Like I have created one user and not accessed it in last one month, should be considered as "not in use".
Thanx & Regds
Jignesh
Printable View
Hi DBAs,
Can somebody tell me how to find whether a particular schema is being used or not in a oracle database.
Like I have created one user and not accessed it in last one month, should be considered as "not in use".
Thanx & Regds
Jignesh
Simply lock the account and wait to see if someone complains ;)
Nice :) but.....Quote:
Originally posted by SANJAY_G
Simply lock the account and wait to see if someone complains ;)
It won't stop someone accessing the schemas objects from another user account.
Clever! :)Quote:
Originally posted by jovery
Nice :) but.....
It won't stop someone accessing the schemas objects from another user account.
My understanding from original post was: "If the user didn't login for a certain period then the account is considered 'not in use'"
At object level auditing can be set using this:
How often tables are accessed (AUDIT)
Hi Sanjay
Thank you that script would do.
regards
Hrishy