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
Articles by SAP Expert
Page 9 of 12
Dropping a SAP HANA database view
You can drop a view using Drop command like we drop a table. You can perform all the operations that you perform on a table on the database view.Drop view "AA_HANA11"."DEMO_TEST";
Read MoreDifferent 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 MoreHow can I upload a Google doc from SAP
This can be done by exporting SAP table as csv file and it can be automatically converted to Google Spreadsheet. Also there are various Google drive API’s that can be used to achieve this programmatically.With use of Google Drive REST API, you can download and upload files in Google drive. To know more about this, check out the below link −Google Link
Read More