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
-
Economics & Finance
SAP Articles
Page 59 of 91
Different options under SAP HANA System Administration
Following tabs are available under SAP HANA Administration Console −OverviewLandscapeAlertsPerformanceVolumesConfigurationSystem InformationDiagnosis FilesTrace Configuration
Read MoreDifferent Audit trial targets in SAP HANA
In SAP HANA system, following audit trail targets are possible −Syslog (default) − Logging system of Linux Operating System.Database Table − Internal database table, user who has Audit admin or Audit operator system privilege he can only run select operation on this table.CSV text − This type of audit trail is only used for test purpose in a non-production environment.
Read MoreDifferent Audit level in an audit policy in SAP HANA
In an Audit policy, you can define different audit levels in SAP HANA −EMERGENCYCRITICALALERTWARNINGINFO
Read MoreSetting validity of a user in SAP HANA
At the time of user creation, you have an option to pass Valid From and Valid Until date.
Read MoreDisabling 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 More