Skip to Content
0

how to find out if a user in HANA is technical User

Apr 27, 2017 at 12:10 AM

104

avatar image

hi, Is there a way we can find out if a user in HANA is technical or not ?

regards

Jonu Joy

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Lucas Oliveira
May 02, 2017 at 05:24 PM
0

Hi Jonu,

What exactly you mean by technical user? An SAP user used on the default connection between SAP app servers and HANA is a technical user in my perspective.

If that's what you meant, then I'd say you need at least the password lifetime disabled (for obvious reasons in this case).

You can get those users by running:

select user_name from users where IS_PASSWORD_LIFETIME_CHECK_ENABLED = 'FALSE'

BRs,

Lucas de Oliveira

Share
10 |10000 characters needed characters left characters exceeded