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 on Trending Technologies
Technical articles with clear explanations and examples
Altering a database view in SAP HANA
You can alter the view, then we can use the Alter View command to alter the view.ExampleAlter view View_EmpInfo as Select Emp_Details.Id, Emp_Details.EmplName, EmpProj.Projname from Emp_Details inner join EmpProjInfo on Emp_Details.Id=EmpProjInfo.Id;We have applied ALTER command to update an existing view with name- View_EmpInfo which is applying Inner Join on two tables on Id column to create a database view.
Read MoreDropping 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 More