Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
SAP HANA Articles
Page 28 of 58
Disabling JDBC/ODBC access to SAP HANA system for a new user
When you create a new user, you need to select checkbox- Disable ODBC/JDBC access −
Read MoreAdding PUBLIC role to restricted user in SAP HANA
It is not possible to add PUBLIC profile to a restricted user. When a restricted user is created, it doesn’t have PUBLIC profile.
Read MoreCreating a Standard user in SAP HANA system using SQL
This can be created using following SQL query −CREATE USER TEST_122 PASSWORD Pass123$$
Read MoreViewing information in M_PASSWORD_POLICY System View in SAP HANA
M_PASSWORD_POLICY System View contains several lines of information about the current password policy.>Select * from M_PASSWORD_POLICY
Read MoreDefining validity of initial password in SAP HANA
This can be defined under Password policy → Miscellaneous
Read MoreCreate User SQL in SAP HANA database
You can achieve this by running the below SQL query −>CREATE USER TEST password “Welcome1$$” VALID FROM ‘2017-12-05 11:00:00’ UNTIL ‘2018-12-08 12:00:00’; CREATE USER DUMMY password “Welcome1$$” VALID FROM NOW UNTIL FOREVER;Note that password passed in this SQL should meet password policy of SAP HANA system otherwise user creation will be failed.
Read MoreChecking existing password policy of SAP HANA system
You can check this information under New User in SAP HANA. The below snapshot shows the New User dialog in SAP HANA Studio and the password rule that is displayed when hovering over the password field.
Read MoreSetting password expire notification in SAP HANA
Parameter password_expire_warning_timeDefault Value 14 (days)Parameter definitionNotification is transmitted via the database client (ODBC or JDBC) and it is up to the client application to provide this information to the user.If you enter the value 0, the user does not receive notification that his or her password is due to expire.The system also monitors when user passwords are due to expire and issues a medium priority alert. This may be useful for technical database users since password expiration results in the user being locked, which may affect application availability. It is recommended that you disable the password lifetime check of technical ...
Read MoreUsing database view in SAP HANA
A view in a database is defined as Virtual table which derives its data from one or more columns of one table or multiple tables. A view can be created using tables of one or more database and is stored in database where it is created.You can find views in SAP HANA Studio under schema name −
Read MoreCalling an ABAP Function Module using Python script to put data in SAP HANA
You can refer this SAP blog how to use SAP NetWeaver library with Python.SAP Link
Read More