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)
Database Duplication Is Failing with Errors ORA-32015 While Restoring spfile
RMAN Command Id : 2025-12-02T16:27:31 RMAN Command Id : 2025-12-02T16:27:31 RMAN Command Id : 2025-12-02T16:27:31 released channel: CH1 re...
-
How to check Clock synchronization between cluster nodes in RAC RHEL - 7 : Applicable We can use below to check the clock/time synchroniz...
-
PDB Lockdown Profiles: - Oracle 12c new feature The PDB lockdown profile is a set of named sets that control operations. Controlling the P...
-
GPnP ( Grid Plug and Play ) profile in Oracle RAC The GPnP profile is a XML file located at location <GRID_HOME/gpnp/<hostname>/p...
No comments:
Post a Comment