Checking existing password policy of SAP HANA system

SAP ABAP Expert
Published on 21-Feb-2018 19:53:05
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.

Setting password expire notification in SAP HANA

SAP ABAP Expert
Published on 21-Feb-2018 19:51:34
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 ... Read More

Setting detailed error notification about failed login in SAP HANA

SAP ABAP Expert
Published on 21-Feb-2018 19:49:38
You can use parameter detailed_error_on_connect: Indicates the detail level of error information returned when a logon attempt fails.Parameter      detailed_error_on_connectDefault Value falseAdditional Information                                                       ... Read More

Using SAP HANA Cockpit for HANA Administration

SAP ABAP Expert
Published on 21-Feb-2018 19:48:06
SAP HANA Cockpit with Fiori-based Launchpad shows the content in the form of tiles arranged in groups. Using these tiles, you can access individual applications and can also access app-specific data for immediate review.You can also perform a drill on these tiles to see the detailed information about specific applications. ... Read More

Performing different SAP logon check while connecting to HANA

SAP ABAP Expert
Published on 21-Feb-2018 19:46:06
When a user logins to the HANA system, the following steps are performed −Step 1 The system authenticates the user using the configured mechanism.Example − When User name/password authentication is being enforced, the provided user name and password are verified.Step 2The system verifies that the user's account is within its validity ... Read More

Password blacklist table in SAP HANA database

SAP ABAP Expert
Published on 21-Feb-2018 19:45:17
The password blacklist in SAP HANA is implemented with the table _SYS_PASSWORD_BLACKLIST in the schema _SYS_SECURITY. This table is empty when you create a new instance.You can enter words in the password blacklist as part of password policy configuration in the Security editor of the SAP HANA studio. Read More

Using Roles tab in SAP HANA system

SAP ABAP Expert
Published on 21-Feb-2018 19:44:09
Roles tab is used to view the existing roles in HANA system and you can also create a new role in HANA system to add to user’s profile as per requirement.

Using database view in SAP HANA

SAP ABAP Expert
Published on 21-Feb-2018 19:42:36
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 ... Read More

Understanding a database view in SAP HANA database

SAP ABAP Expert
Published on 21-Feb-2018 19:40:32
Consider the following example −Example            Id            Empl. NameEmpl.userEmpl.passwordJoining Date1 Employee 1  Emp1Emp1Pwd      9/11/20162 Employee 2Emp2Emp2Pwd16/08/20153Employee 3 Emp3Emp3Pwd  15/09/20164Employee 4Emp4  Emp4Pwd3/07/20145Employee 5  Emp5    Emp5Pwd 10/09/20126 Employee 6Emp6  Emp6Pwd  1/10/2013         Consider a scenario when a developer needs to analyze some data ... Read More

Benefits of using SAP HANA database views

SAP ABAP Expert
Published on 21-Feb-2018 19:39:31
Following benefits can be achieved using database views −To provide security −Using a view, you can select specific columns and assign access to the users. Users can only see the columns for which permissions are set on the view and not the underlying tables with full data.To hide Complexity −Consider ... Read More
Advertisements