oracle list user locked
Solutions on MaxInterview for oracle list user locked by the best coders in the world
{{#items}}
{{text}}
{{/items}} {{ctaText}}
{{#items}} {{/items}}
showing results for - "oracle list user locked"
Souleymane
28 Jun 2020
1SELECT * FROM DBA_USERS WHERE ACCOUNT_STATUS <> 'OPEN';
2-- Unlock a user
3ALTER USER my_user ACCOUNT UNLOCK;
4-- If password is expired
5ALTER USER my_user IDENTIFIED BY new_password ACCOUNT UNLOCK;similar questions
oracle sql create useroracle unlock accountoracle list usersoracle grantsoracle allow space to useroracle list grants on packageoracle drop useroracle user privilegesoracle role useroracle show grants on tableoracle last user logonoracle unlock useroracle identify sql holding lockoracle privileges userslocked tables in oracledefault username and password for oracle 11goracle list privilegeshow to check grants on a package in oracleoracle locked objectsselect dba users oracleoracle sysdba connect as another useroracle user last connectedoracle limit user tablespacehow to find username and password in oracle 18coracle user tablesoracle list user defined typesoracle drop all user viewsoracle list user grants your answer for
you will get a confirmation link on this - you will have to click that for successful submission of your answer. we require this to keep the website free of spam, bots and unhelpful content
please ensure to add code which is syntactically corrent and executes properly
ask question on maxinterview
you will get a confirmation link on this - you will have to click that for successful submission of your question. we require this to keep the website free of spam, bots and unhelpful content
please be clear, to the point and respectful