Skip to content

Latest commit

 

History

History
89 lines (45 loc) · 5.84 KB

create-a-database-administrator-user-c0fce6f.md

File metadata and controls

89 lines (45 loc) · 5.84 KB

Create a Database Administrator User

As an subaccount administrator, you can use the database user feature provided in the cockpit to create your own database user for your SAP HANA database.

Context

Remember:

SAP Business Technology Platform, Neo environment will sunset on December 31, 2028, subject to terms of customer or partner contracts.

For more information, see SAP Note 3351844.

Tip:

This documentation refers to SAP Business Technology Platform, Neo environment. If you are looking for documentation about other environments, see SAP Business Technology Platform ↗️.

SAP BTP creates four users that it requires to manage the database: SYSTEM, BKPMON, CERTADM, and PSADBA. These users are reserved for use by SAP BTP.

Caution:

Do not delete or deactivate these users or change their passwords.

Procedure

  1. In the SAP BTP cockpit, navigate to a subaccount. For more information, see Navigate in the Cockpit.

  2. Choose SAP HANA / SAP ASE > Databases and Schemas in the navigation area.

    You see all databases that are available in the subaccount, along with their details, including the database type, version, memory size, state, and the number of associated databases.

  3. Select the relevant SAP HANA XS database.

  4. In the Development Tools section, click Database User.

    A message confirms that you do not yet have a database user.

  5. Choose Create User.

    Your user and initial password are displayed. Change the initial password when you first log on to an SAP HANA system, for example the SAP HANA Web-based Development Workbench.

    Note:

    • Your database user is assigned a set of permissions for administering the SAP HANA database system, which includes HCP_PUBLIC, and HCP_SYSTEM. The HCP_SYSTEM role contains, for example, privileges that allow you to create database users and grant additional roles to your own and other database users.

    • You also require specific roles to use the SAP HANA Web-based tools. For security reasons, only the role that provides access to the SAP HANA Web-based Development Workbench is assigned as default.

  6. To log on to the SAP HANA Web-based Development Workbench and change your initial password now (recommended), copy your initial password and then close the dialog box.

    You do not have to change your initial password immediately. You can open the dialog box again later to display both your database user and initial password. Since this poses a potential security risk, however, you are strongly advised to change your password as soon as possible.

  7. In the Development Tools section, click SAP HANA Web-based Development Workbench.

  8. On the SAP HANA logon screen, enter your database user and initial password.

  9. Change your password when prompted.

    Caution:

    You are responsible for choosing a strong password and keeping it secure. If your user is blocked or if you've forgotten the password of your user, another database administration user with USER_ADMIN privileges can unlock your user.

Next Steps

  • Tip:

    There may be some roles that you cannot assign to your own database user. In this case, we recommend that you create a second database user (for example, ROLE_GRANTOR) and assign it the HCP_SYSTEM role. Then log onto the SAP HANA system with that user and grant your database user the roles you require.

  • In the SAP HANA system, you can now create database users for the members of your subaccount and assign them the required developer roles.

  • To be able to use other HANA tools like HANA Cockpit or HANA XS Administration tool, you must assign yourself access to these before you can start using them. See Assign Roles Required for the SAP HANA XS Administration Tool

Related Information

Roles Required for Web-based Tools

Managing SAP HANA Users

Setting Up Roles and Authorizations

Creating an SAP HANA Tenant Database and an SAP HANA XS Classic Application ↗️