Recreated view in postgress, errors appeared in the project

SQLSTATE[42501]: Insufficient privilege: 7 ERROR: permission denied for relation table213 CONTEXT: PL/pgSQL

in navikat all requests pass, mb need to restart the database?

  • one
    to be honest with PL / pgSQL did not work, but I think because of the re-creation, you lost the rights to the view from the user from which you are accessing it. Try to give again. - heff
  • 2
    Yes, when re-creating the view and other objects, the rights fly off. need to re-issue rights with something like grant select on view_name to user_name - Mike

0