top of page
Search

Database Users (with last password change date)

select s.name "User", p.granted_role "Role", s.ptime "Password change date"

from dba_role_privs p,

sys.user$ s,

dba_users d

where s.name = p.grantee

and d.username = s.name

and d.account_status = 'OPEN'

order by 1,2,3;

 
 
 

Recent Posts

See All
Get DDL for Oracle object

set feed off set long 1000000 set longchunksize 1000000 set pages 0 set lines 32767 set trimspool on set feed off set wrap on set...

 
 
 
Foreign key constraint violation

/* This PL/SQL script checks violations of foreign key constraints Example of the tables: CREATE TABLE temp_supplier ( supplier_id...

 
 
 

Comments


bottom of page