search

CartoDB / observatory-extension

BSD 3-Clause "New" or "Revised" License
6 stars 4 forks source link

OBS_DumpVersion should be created with security definer #132

Closed iriberri closed 7 years ago

iriberri commented 8 years ago

Otherwise:

REMOTE ERROR: cdb_dataservices_server.obs_dumpversion(2): [observatory] REMOTE ERROR: permission denied for schema observatory
LINE 2:     SELECT MAX(dump_id) FROM observatory.obs_dump_version
                                     ^
QUERY:  
    SELECT MAX(dump_id) FROM observatory.obs_dump_version

CONTEXT:  Remote context: Remote context: PL/pgSQL function cdb_observatory.obs_dumpversion() line 5 at EXECUTE
SQL statement "SELECT * FROM cdb_dataservices_client._obs_dumpversion(username, orgname)"
PL/pgSQL function obs_dumpversion() line 16 at SQL statement
talos commented 7 years ago

This was taken care of.