on 11-24-2011 6:38 AM
#HANA gurus
In the HANA Studio I create a user, which gets locked for whatever reason. Within Studio, I see an option to change the password of the user, but no option to unlock it! Sure I am missing something, please help.
Regards
Manish Madhav
Hi!
Do You see any invalid connect attempts for requested user?
select * from sys.INVALID_CONNECT_ATTEMPTS where user_name='USER BACKUP_ADMIN'
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Well, very likely you're hitting a known bug in the HANA studio, that leads to a situation where the studio still uses the old logon data even after you changed the password.
This leads to multiple failed logons and eventually to the locking of the user.
The command to change this is:
alter user <username> DROP CONNECT ATTEMPTS;
After that the user should be ready for logon again.
If the user was locked/deactivated for other reasons (e.g. directly by a user admin), you may need to reset the password:
alter user <username> password <password>;
See [SAP HANA Database - SQL Reference Guide|https://service.sap.com/~sapidb/011000358700000604922011] for details of all commands.
(And, yes, sure, this is just about SPS 03/rev. 20 or higher ).
best regards,
Lars
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Tested the command, it works, but not solve the issue, as it says 0 rows affected!
Statement 'ALTER USER BACKUP_ADMIN RESET CONNECT ATTEMPTS' successfully executed in 33 ms 247 µs - Rows Affected: 0
And:
Statement 'ALTER USER BACKUP_ADMIN DROP CONNECT ATTEMPTS' successfully executed in 40 ms 309 µs - Rows Affected: 0
Tried putting ' ' and " " around the user name, but no luck.
Hello,
Tested the command, it works, but not solve the issue, as it says 0 rows affected!
Do not put too much importance to the message "Rows Affected: 0". It is usually there with 0 unless you directly modify some row with statement like UPDATE or DELETE. Check if user is still locked or not.
You can also use following query (or its modifications) to see if user is deactivated or how many invalid logons he has:
SELECT NAME, USER_DEACTIVATED, INVALID_CONNECT_ATTEMPTS FROM "SYS"."P_PRINCIPALS_" WHERE NAME='BACKUP_ADMIN'Tomas
Hi,
recently, I got AHANA Access, I am learning HANA Modeling Information Views,
but in the Add System Area it showing a massage that is "Secure Storage is locked ". I am unable to understand what is this ? and how resolve this problem?
it is my first experience to see it. and it does not show add systems also.
i attached screen shot , that would give better view of the problem.
Please help me to resolve this problem.
Ankit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 3 | |
| 3 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.