Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Create technical user in HANA

Former Member
0 Kudos

Hi Team,

I need to know how to create a technical user (password does not expire) in HANA using HANA studio.

Also for an existing user how can i make sure that the password does not expire.

Regards,

Yasmin

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Try this.

ALTER USER <USERID> DISABLE PASSWORD LIFETIME;

5 REPLIES 5

Former Member
0 Kudos

Try this.

ALTER USER <USERID> DISABLE PASSWORD LIFETIME;

0 Kudos

This command is correct. However is there an alternate way from HANA studio instead of executing the SQL command.

0 Kudos

No its not possible. Since there is no concept of User Type in HANA Studio, the only way to do it is via SQL.

0 Kudos

Thanks!

Is there any special privilege needed to execute this command?

0 Kudos

Off course you need User Admin.