Skip to Content
0

HANA User SQL report

Dec 08, 2017 at 02:44 AM

50

avatar image
Former Member

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
10 |10000 characters needed characters left 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;

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Florian Pfeffer
Dec 09, 2017 at 05:33 AM
0

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

Regards,
Floran

Share
10 |10000 characters needed characters left characters exceeded