<\/p>\n
prompt Database User Password Expired Check\r\nprompt _______________________________________________________\r\nprompt\r\n\r\ncol ACCOUNT_STATUS for a18\r\ncol LIMIT for a15\r\ncol LAST_PWD_CHG_DT for a20\r\ncol EXPIRED_PWD_DT for a20\r\n \r\nselect u.USERNAME,u.ACCOUNT_STATUS,u.LOCK_DATE,u.EXPIRY_DATE,u.CREATED,u1.ptime as \"LAST_PWD_CHG_DT\", P.LIMIT ,\r\n decode ( P.LIMIT , 'UNLIMITED','9999\/12\/31' , 'DEFAULT', to_char(u1.ptime+180,'YYYY\/MM\/DD' ) , to_char(u1.ptime+to_number(P.LIMIT),'YYYY\/MM\/DD' ) ) as \"EXPIRED_PWD_DT\"\r\n from dba_users u,sys.user$ u1 , dba_profiles p\r\n where u.username=u1.name\r\nand u.profile = p.profile\r\nand username not in ('SYSAUX','SYSMAN','XDB','HR','ODM','OUTLN','OE','SH','PM','IX','WK_TEST','PERFSTAT','DBSNMP','OLAPSYS','QS_CS','QS_CB','QS_CBADM','QS_OS','QS_WS','QS','QS_ADM','ODM_MTR' ,'WKPROXY','QS_ES','ANONYMOUS','WKSYS','WMSYS','APEX_030200','APEX_PUBLIC_USER','APPQOSSYS','BI','CTXSYS','DIP','EXFSYS','FLOWS_FILES','MDDATA','MDSYS','MGMT_VIEW','ORACLE_OCM','ORDDATA','ORDPLUGINS','ORDSYS','OWBSYS','OWBSYS_AUDIT','SCOTT','SI_INFORMTN_SCHEMA','SPATIAL_CSW_ADMIN_USR','SPATIAL_WFS_ADMIN_USR','XS$NULL')\r\nand p.RESOURCE_NAME='PASSWORD_LIFE_TIME'\r\n\/<\/pre>\n","protected":false},"excerpt":{"rendered":" prompt Database User Password Expired Check prompt _______________________________________________________ prompt col ACCOUNT_STATUS for a18 col LIMIT for a15 col LAST_PWD_CHG_DT for a20 col EXPIRED_PWD_DT for a20 select u.USERNAME,u.ACCOUNT_STATUS,u.LOCK_DATE,u.EXPIRY_DATE,u.CREATED,u1.ptime as “LAST_PWD_CHG_DT”, P.LIMIT , decode ( P.LIMIT , ‘UNLIMITED’,’9999\/12\/31′ , ‘DEFAULT’, to_char(u1.ptime+180,’YYYY\/MM\/DD’ ) , to_char(u1.ptime+to_number(P.LIMIT),’YYYY\/MM\/DD’ ) ) as “EXPIRED_PWD_DT” from dba_users u,sys.user$ u1 , dba_profiles p where […]<\/p>\n","protected":false},"author":1,"featured_media":2864,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[3],"tags":[945,944],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/02\/cl500.jpg?fit=500%2C399","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2854"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2854"}],"version-history":[{"count":1,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2854\/revisions"}],"predecessor-version":[{"id":2855,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2854\/revisions\/2855"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/2864"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2854"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2854"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2854"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}