Define the Password Lifetime for a Database User
- How to define a password lifetime policy in your tenant
- How to apply password lifetime policy for your database users
- You have understood different roles, and are assigned the SAP Datasphere Administrator role.
- You have created a database user in your Space.
- Step 1
SAP Datasphere allows you to connect to 3rd-party ETL and BI tools by using database users. Each user has its own set of credentials, including passwords. To help you better meet your security needs, we have introduced an option to manage password lifetime for database users. This feature allows you to:
Define a global tenant-wide password lifetime policy.
Remain flexible – for each database user, decide whether the lifetime policy applies.
Improve compliance with corporate password policies.
You need the SAP Datasphere Administrator role to configure the password policy.
To define the password policy, go to Configuration > Security
Here, you can enter the number of days for which the initial password or any password set by a user administrator for a user is valid.
If a user has not logged on using the initial password within the given period of time, the user will be deactivated until their password is reset.
- Step 2
You can apply the policy when creating a new database user by selecting Enable Password Policy as shown below.
For an existing user, simply select the database user and mark the checkbox. You have now successfully applied your password policy for your database user.
You have completed the 9th tutorial of this group. Now you know how to define the password lifetime for a database user in SAP Datasphere.
Learn in the next tutorial how to connect your Space to an SAP HANA Cloud, data lake in SAP Datasphere.
- Step 3
What role should you be assigned in order to assign password policies for database users?