CODEWITHSUNDEEP
sqlpostgresqlnavicat
Ralam
Ralam

Reputation: 21

GRANT command return ERROR: EXPLAIN GRANT

In the application Navicat for PostgreSQL I am trying to apply a command to issue permissions to update a materialized view for a user.

GRANT REFRESH ON MATERIALIZED VIEW *materialized_view* TO *user*;

But I am getting this error:

ERROR:  syntax error at or near "GRANT"
LINE 1: EXPLAIN GRANT REFRESH ON MATERIALIZED VIEW materialized_view...
                
, Time: 0.073000s

I'm new to database administration, can you tell me what could be wrong with my command? I would also be grateful, "if you throw at me" documentation

I tried to find at least some answers, but could not

Upvotes: 0

Views: 85

Answers (0)

Related Questions