Skip to Content

Define the Password Lifetime for a Database User

test
0 %
Define the Password Lifetime for a Database User
Details

Define the Password Lifetime for a Database User

September 1, 2021
Created by
September 1, 2021
Define a password lifetime for database users to help better meet your security needs for SAP Data Warehouse Cloud.

You will learn

  • How to define a password lifetime policy in your tenant
  • How to apply password lifetime policy for your database users
QR code

Prerequisites


Step 1: Define a global password policy

SAP Data Warehouse Cloud 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 DW Administrator role to configure the password policy.

To define the password policy, go to Configuration > Security

Password Policy

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.

Log on to answer question
Step 2: Apply password policy to database user

You can apply the policy when creating a new database user by selecting Enable Password Policy as shown below.

Enable

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.

Well done!

You have completed the 9th tutorial of this group. Now you know how to define the password lifetime for a database user in SAP Data Warehouse Cloud.

Learn in the next tutorial how to connect your Space to an SAP HANA Cloud, data lake in SAP Data Warehouse Cloud.

Log on to answer question
Step 3: Test yourself
What role should you be assigned in order to assign password policies for database users?
×

Next Steps

Back to top