How can I check user privileges in Memgraph?

Question

I've checked the documentation for managing user privileges (https://memgraph.com/docs/memgraph/how-to-guides/manage-user-privileges) and I've created a new user:

CREATE USER `james@skyfalllodge.co.uk` IDENTIFIED BY '007';

And I've added the privileges:

GRANT MATCH, MERGE, CREATE, DELETE, REMOVE, SET TO `james@skyfalllodge.co.uk`

How can I check if the privileges are assign? Do I need to try to run queries using MATCH, MERGE, CREATE, DELETE, REMOVE to test it out?

score 2 · Accepted Answer · answered May 24 '23 at 14:18

The query that you are looking for is

SHOW PRIVILEGES FOR `james@skyfalllodge.co.uk`

P.S. The query that you have listed (GRANT MATCH, MERGE, CREATE, DELETE, REMOVE SET TO james@skyfalllodge.co.uk) has a typo. You are missing a comma after remove. Please fix this.

How can I check user privileges in Memgraph?

1 Answers1