Reputation: 235
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 `[email protected]` IDENTIFIED BY '007';
And I've added the privileges:
GRANT MATCH, MERGE, CREATE, DELETE, REMOVE, SET TO `[email protected]`
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?
Upvotes: 0
Views: 55
Reputation: 63
The query that you are looking for is
SHOW PRIVILEGES FOR `[email protected]`
P.S. The query that you have listed (GRANT MATCH, MERGE, CREATE, DELETE, REMOVE SET TO [email protected]
) has a typo. You are missing a comma after remove. Please fix this.
Upvotes: 2