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)
Undo Queries
SQL> SQL> select sum(bytes /(1024*1024*1024)) from dba_undo_extents where status='EXPIRED'; select sum(bytes /(1024*1024*102...
-
Installation on Oracle Linux Part-1 OS 1. PREPARING OPERATING SYSTEMS ON BOTH SERVERS It is assumed that you have two servers running on ...
-
How To Manually Install Oracle OEM 13c Agent? STEPS : 1- We need to download the agent software from OMS Server for the platform wh...
-
Description:- Step by Step Applying PSU Patch in Oracle 19c in Windows Environment Prerequisites to Apply Patch :-Database Release Update ...
No comments:
Post a Comment