Query to check whether database has any externally authenticated SSL users
Please use the below query.
SELECT name FROM sys.user$
WHERE ext_username IS NOT NULL
AND password = ‘GLOBAL’;
Related blogs
Database Blog
Query to Identify Initial and Latest Login Sessions in Oracle Database
Please use the query below to identify and provide the SID and Serial#. col first_seen for a30 col last_seen for a30 SELECT MIN(sample_time) AS first_see…
Database Blog
Steps to Renew Default OHS Keystore Wallet in Oracle Enterprise Manager (OEM)
Please follow the below steps. Prerequisites Take a backup of the existing wallet. Ensure you have appropriate Oracle user privileges. Verify OMS…
Database Blog
How to Unlock Locked SQL Server Logins
How to Unlock Locked SQL Server Logins Introduction / Issue During day-to-day SQL Server administration, users may report that they are unable to connect to the…