Everything for SAP Hana / Basis /Technology / BO / BW

Check Users; select * from users where user_deactivated= ‘TRUE’; Deactive hana user We can use the following SQL query to DEACTIVATE HANA DB user ; ALTER USER DEACTIVATE USER NOW; Example ; alter user HanaUser deactivate user now; To activate the user again we can use the below SQL query ; ALTER USER ACTIVATE USER NOW; Example ; alter user Hanauser activate user now;

Copy command Remote   scp -pr HDBSp3.zip 'domain\user1'@servername:/var/tmp Delete Command: Rm command Rm -ir folder Permission : ---> Group und Permission / Berechtigung Chown -R root.root File Permission Chmod -R 755 File Check User Lock or not / User Entsperrt oder Gesperrt net user %username% /dom

To change your shell with  chsh : cat /etc/shells At the shell prompt, list the available shells on your system with  cat /etc/shells . chsh Enter  chsh  (for "change shell"). Code Listing 3.5 shows the system response. Some systems prompt for a password, and some don't. /bin/zsh Type in the path and name of your new shell. su - yourid Type in  su -  and your userid to relog in to verify that everything works correctly. If it doesn't, use  chsh  again and change back to the original shell or to a different one. If you can't change back, email your system administrator for help.