Skip to Content

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

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

regards

Jonu Joy

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 02, 2017 at 05:24 PM

    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

    Add comment
    10|10000 characters needed characters exceeded