GrandMel
GrandMel

Reputation: 235

How can I check user privileges in Memgraph?

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

Answers (1)

TalyaDan
TalyaDan

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

Related Questions