Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

find last time users logged in

RobeenJul 25 2017 — edited Nov 11 2017

Oracle Database 11.2.0.4

Hi,

how do I find last time users logged in and those who did not login for past 180 days

USERNAME                                      PROFILE                        ACCOUNT_STATUS

--------------------------------------------- ------------------------------ ------------------------------

SYS                                           DEFAULT                        OPEN

SYSTEM                                        DEFAULT                        OPEN

OUTLN                                         DEFAULT                        EXPIRED & LOCKED

DIP                                           DEFAULT                        EXPIRED & LOCKED

MUZAMMER                                      DEFAULT                        OPEN

DBSNMP                                        DEFAULT                        OPEN

APPQOSSYS                                     DEFAULT                        EXPIRED & LOCKED

WMSYS                                         DEFAULT                        EXPIRED & LOCKED

XS$NULL                                       DEFAULT                        EXPIRED & LOCKED

EXFSYS                                        DEFAULT                        EXPIRED & LOCKED

XDB                                           DEFAULT                        EXPIRED & LOCKED

USERNAME                                      PROFILE                        ACCOUNT_STATUS

--------------------------------------------- ------------------------------ ------------------------------

ANONYMOUS                                     DEFAULT                        LOCKED

ORDSYS                                        DEFAULT                        EXPIRED & LOCKED

ORDDATA                                       DEFAULT                        EXPIRED & LOCKED

ORDPLUGINS                                    DEFAULT                        EXPIRED & LOCKED

SI_INFORMTN_SCHEMA                            DEFAULT                        EXPIRED & LOCKED

MDSYS                                         NICE_PROFILE                   OPEN

MDDATA                                        DEFAULT                        EXPIRED & LOCKED

SPATIAL_WFS_ADMIN_USR                         DEFAULT                        EXPIRED & LOCKED

PP2                                           DEFAULT                        OPEN

SPATIAL_CSW_ADMIN_USR                         DEFAULT                        EXPIRED & LOCKED

DBADM                                         NICE_PROFILE                   OPEN

Regards,

Roshan

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 9 2017
Added on Jul 25 2017
47 comments
78,308 views