Create and manage users

Prerequisites

• You have created a PostgreSQL Flex instance.
  Check Create and manage instances for PostgreSQL Flex.

List, create, view and delete a user

List users

STACKIT CLI

To get a list of all users for a PostgreSQL Flex instance:

Flag	Description
instance-id	Instance ID of the instance you want to query

stackit postgresqlflex user list --instance-id <instance-id>

You get something like the following output:

 ID    │ USERNAME
───────┼───────────────────
 16843 │ crm-tutorial-user

STACKIT Portal

1. Open your project in the STACKIT Portal.
2. Navigate to Databases > PostgreSQL Flex.
3. Choose your instance and go to the overview.
4. In the sidebar, select Users.

Now you can see the list of users.

Create a user

STACKIT CLI

To create a user for a PostgreSQL Flex instance:

Flag	Description	Default	Optional
instance-id	Instance ID of the instance you want to query
username	Username of the new user
role	Permissions of the user (login, createdb)	login	x

stackit postgresflex user create --instance-id <instance-id> --username <username> --role <first-role> --role <second-role> ...

You get the following output:

Created user for instance "postgres-qaeq2npfyl75". User ID: 16853

Username: stackit-user-guide-users
Password: pEjB7MK7HRaLfiNAECnObgpY03w1710p5ZfUAyHkDe2hY5vJqhoiMjOVKFLy986e
Roles: [login createdb]
Host: a9b3b1dd-308e-4a00-b269-11d136e65824.postgresql.eu01.onstackit.cloud
Port: 5432
URI: postgresql://stackit-user-guide-users:pEjB7MK7HRaLfiNAECnObgpY03w1710p5ZfUAyHkDe2hY5vJqhoiMjOVKFLy986e@a9b3b1dd-308e-4a00-b269-11d136e65824.postgresql.eu01.onstackit.cloud:5432/stackit

You can not retrieve the password nor the connection string afterwards. Copy it right now to a safe location.

STACKIT Portal

1. Open your project in the STACKIT Portal.
2. Navigate to Databases > PostgreSQL Flex.
3. Choose your instance and go to the overview.
4. In the sidebar, select Users.
5. In the top bar, click on Create user.
6. Enter a username.
7. In the Role menu, add CreateDB and Login.
8. Click on Create.
9. Copy all information to a safe place. You can’t retrieve it again.

View a user

STACKIT CLI

To get details of a user for a PostgreSQL Flex instance:

Flag	Description	Default	Optional
instance-id	Instance ID of the instance you want to query
user-id	The ID of the user (not its username)

stackit postgresqlflex user describe <user-id> --instance-id <instance-id>

You get the following output:

ID       │ 16690
─────────┼──────────────────────────────────────────────────────────────────────
USERNAME │ stackit-user-guide-users
─────────┼──────────────────────────────────────────────────────────────────────
ROLES    │ [createdb login]
─────────┼──────────────────────────────────────────────────────────────────────
HOST     │ a9b3b1dd-308e-4a00-b269-11d136e65824.postgresql.eu01.onstackit.cloud
─────────┼──────────────────────────────────────────────────────────────────────
PORT     │ 5432

Enter the User ID of the user, not its username.

STACKIT Portal

1. Open your project in the STACKIT Portal.
2. Navigate to Databases > PostgreSQL Flex.
3. Choose your instance and go to the overview.
4. In the sidebar, select Users.
5. Click on the user entry you want to view.

Delete a user

STACKIT CLI

To delete a user for a PostgreSQL Flex instance:

Flag	Description	Default	Optional
instance-id	Instance ID of the instance you want to query
user-id	The ID of the user (not its username)

stackit PostgreSQLflex user delete <user-id> --instance-id <instance-id>

After confirmation, you get the following output:

Deleted user "z8n9ybsi" of instance "PostgreSQL-87ffl67rc1dd"

Enter the User ID of the user, not its username.

STACKIT Portal

1. Open your project in the STACKIT Portal.
2. Navigate to Databases > PostgreSQL Flex.
3. Choose your instance and go to the overview.
4. In the sidebar, select Users.
5. Click on the three dots on the right side of a user entry.
6. Click on Delete.

You cannot delete a user when it owns databases or other objects. In this case, you need to delete the depending objects first.