Tag Archives: HANA sql queries

SQL Commands used for HANA database user

SQL Commands used for HANA database user The following sql command will show details for all sap hana users with deactivated status. Query: select USER_NAME, USER_DEACTIVATED from “SYS”.”USERS”; After executing the command, we will get below message: Statement ‘select USER_NAME, USER_DEACTIVATED from “SYS”.”USERS”‘ successfully executed in 247 ms 698 µs (server processing time: 0 ms… Read More »