Friday, 1 October 2021
How to reset password with knowing user password in Oracle Database
SQL> select username,account_status from dba_users where username='SAMIK';
SQL> select 'alter user "'||d.username||'" identified by values '''||u.password||''';' c from dba_users d, sys.user$ u where d.username = upper('&&username') and u.user# = d.user_id;
User altered.
Subscribe to:
Post Comments (Atom)
Understanding SQL Plan Baselines in Oracle Database
Understanding SQL Plan Baselines in Oracle Database SQL Plan Baseline is the feature in Oracle started from Database 11g that helps to pre...
-
What Is OEM? Oracle Enterprise Manager (OEM) has built-in management capabilities that enable DBAs and Apps DBAs to monitor and ma...
-
Oracle ASMCMD is ASM command-line utility that you can use to manage Oracle ASM instances, disk groups, file access control for disk groups,...
-
To explain the difference between local prefixed indexes and local non-prefixed indexes in Oracle, let's break it down step by step ...
No comments:
Post a Comment