I'm working with GridDB and attempting to create a new user and grant it privileges on a specific database. However, I keep encountering the following error:

10090 TXN_OTHER_PRIVILEGE_EXISTS ERROR User/DB administration operation
failed. Authority may have been duplicated. Check the user name and DB name.

I suspect this issue arises due to duplicate privileges, but I'm not sure how to resolve it.

Here’s a minimal example of what I’m trying to do:

-- Create a new user
CREATE USER test_user WITH PASSWORD 'securepassword';

-- Grant privileges to the user
GRANT ALL PRIVILEGES ON test_db TO test_user;

However, when I execute this, I get the 10090 TXN_OTHER_PRIVILEGE_EXISTS error.

What I've tried: Checked if the user already exists before creating it. Verified the database and user privilege assignments. Tried revoking and reassigning privileges. Restarted the GridDB service to see if it's a session-related issue.

What does this error specifically indicate? How can I check existing user privileges to avoid duplication? What is the proper way to manage user privileges in GridDB without hitting this issue? Any insights or solutions would be greatly appreciated! Thanks in advance.