import os
from cognite.client.data_classes.postgres_gateway import UserUpdate, SessionCredentials
from cognite.client.data_classes import ClientCredentials
session = client.iam.sessions.create(
    ClientCredentials(os.environ["IDP_CLIENT_ID"], os.environ["IDP_CLIENT_SECRET"]),
    session_type="CLIENT_CREDENTIALS"
)
update = UserUpdate('myUser').credentials.set(SessionCredentials(nonce=session.nonce))
res = client.postgres_gateway.users.update(update)

{
  "items": [
    {
      "username": "<string>",
      "createdTime": 1730204346000,
      "lastUpdatedTime": 1730204346000,
      "sessionId": 4503599627370496
    }
  ],
  "nextCursor": "<string>"
}