cancel
Showing results for 
Search instead for 
Did you mean: 

HANA user passwd

Former Member
0 Kudos
68

hi all,

How can we find out  if a user has a password defined in HANA DB or if the password is disabled and also how can we find when a users password would expire .

Thank you

Jonu Joy

View Entire Topic
Former Member
0 Kudos

Hi Jonu,

Check out the Security Guide from HANA. You can find the ways to check the users in HANA.

http://help.sap.com/hana/SAP_HANA_Security_Guide_en.pdf

You can do this with via HANA Studio in Security / Authorizations tab or via SQL.

Best Regards,

Enio Terra

Former Member
0 Kudos

cant find in the security guide on how to check when a users password would expire( the date)  and if the users has passwd disabled ( disable passwd lifetime)

0 Kudos

you can run the following query:

select * from users;

Former Member
0 Kudos

  thx much jodi

Former Member
0 Kudos

i can see a field in users tables 'passwd change needed' which if false means that the user has passwd lifetime disabled but coudnt find a date column for a user with passwd which says when his passwd would expire

Thank you

Jonu Joy

GS
Employee
Employee
0 Kudos

The 'date column' will come into picture for the users whose password need to change after a certain defined period. Just see for _EPM,_AFL,_DATAPROV as example.

Former Member
0 Kudos

thx much Gaurav