Skip to Content
avatar image
Former Member

HANA User SQL report

I am looking for a HANA SQL report that will produce a report similar to this:

UserName Status - Active? Profile Pasword Expiry Date Schema_Owner? Role
DBSNMP EXPIRED & LOCKED DEFAULT 20-Sep-13 Y CDB_DBA
Add comment
10|10000 characters needed characters exceeded

  • Former Member

    This statement gets me closer to what I need but I need a way to also get the roles or privileges.

    select
    USER_NAME , USER_DEACTIVATED, DEACTIVATION_TIME, PASSWORD_CHANGE_NEEDED, IS_PASSWORD_ENABLED
    from USERS
    ORDER BY 1;

  • Get RSS Feed

1 Answer

  • Dec 09, 2017 at 05:33 AM

    Maybe you wanna check the official documentation. Then you would find things like

    Regards,
    Floran

    Add comment
    10|10000 characters needed characters exceeded