Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

When connecting as a non-superuser, a "permission denied" error occurs. #2144

Open
levin-kitty opened this issue Jan 7, 2025 · 1 comment
Labels
question Further information is requested

Comments

@levin-kitty
Copy link

I followed the guide from Apache AGE Documentation, but the error persists.

Type "help" for help.

mint=>
mint=>
mint=> LOAD '$libdir/plugins/age';
LOAD
mint=> SELECT * FROM pg_extension;
  oid  | extname | extowner | extnamespace | extrelocatable | extversion |   extconfig   | extcondition
-------+---------+----------+--------------+----------------+------------+---------------+--------------
 13533 | plpgsql |       10 |           11 | f              | 1.0        |               |
 18895 | age     |       10 |        16397 | f              | 1.5.0      | {18896,18908} | {"",""}
(2 rows)

mint=> SET search_path = ag_catalog, "$user", public;
SET
mint=> SELECT * FROM create_graph('herb');
ERROR:  permission denied for database mint

When connecting as a superuser, everything works as expected.
What might I have missed?

@levin-kitty levin-kitty added the question Further information is requested label Jan 7, 2025
@MuhammadTahaNaveed
Copy link
Member

MuhammadTahaNaveed commented Jan 18, 2025

@levin-kitty You have to grant CREATE privilege to user.

 GRANT CREATE ON DATABASE mint TO test_user;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
question Further information is requested
Projects
None yet
Development

No branches or pull requests

2 participants