Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
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.
In an Audit policy, you can define different audit levels in SAP HANA −EMERGENCYCRITICALALERTWARNINGINFO
At the time of user creation, you have an option to pass Valid From and Valid Until date.
When you create a new user, you need to select checkbox- Disable ODBC/JDBC access −
You can create a restricted user by navigating to Security tab → UsersWhen you select New Restricted User option, it will open New user creation window, and you have to pass the details as requested.
SAP HANA Data Modeling feature allows you to create complex BI reports in real time and it can be easily integrated with different BI tools- Business Objects, Crystal Report, SAP Lumira and non-SAP tools like Microsoft Excel with use of MDX client as shown below.
It is not possible to add PUBLIC profile to a restricted user. When a restricted user is created, it doesn’t have PUBLIC profile.
This can be created using following SQL query −CREATE USER TEST_122 PASSWORD Pass123$$
M_PASSWORD_POLICY System View contains several lines of information about the current password policy.>Select * from M_PASSWORD_POLICY
This can be defined under Password policy → Miscellaneous