Supabase update OpenAPI access

🟢SQL

Hi,

Does the following change: https://github.com/orgs/supabase/discussions/42949
interfere with my existing solution, I would still like to keep it so service_role cant use OpenAPI after the change, I however cant find how this change works, does it occur at the api level or does it also alter role like I do, which will likely interfere:

create function api.root() returns jsonb
    language plpgsql
    immutable set search_path = '' as $$
begin
    return '{
      "swagger": "2.0",
      "info": {
        "title": "Private API",
        "version": "1.0.0",
        "description": "This API is not publicly documented."
      },
      "paths": {}
    }'::jsonb;
end; $$;

grant execute on function api.root () to anon, authenticated, service_role;
-- noqa: disable=all
alter role anon set pgrst.db_root_spec = 'api.root';

alter role authenticated set pgrst.db_root_spec = 'api.root';

alter role service_role set pgrst.db_root_spec = 'api.root';
-- noqa: enable=all

create function api.root() returns jsonb
    language plpgsql
    immutable set search_path = '' as $$
begin
    return '{
      "swagger": "2.0",
      "info": {
        "title": "Private API",
        "version": "1.0.0",
        "description": "This API is not publicly documented."
      },
      "paths": {}
    }'::jsonb;
end; $$;

grant execute on function api.root () to anon, authenticated, service_role;
-- noqa: disable=all
alter role anon set pgrst.db_root_spec = 'api.root';

alter role authenticated set pgrst.db_root_spec = 'api.root';

alter role service_role set pgrst.db_root_spec = 'api.root';
-- noqa: enable=all

🟢SQL

create function api.root() returns jsonb
    language plpgsql
    immutable set search_path = '' as $$
begin
    return '{
      "swagger": "2.0",
      "info": {
        "title": "Private API",
        "version": "1.0.0",
        "description": "This API is not publicly documented."
      },
      "paths": {}
    }'::jsonb;
end; $$;

grant execute on function api.root () to anon, authenticated, service_role;
-- noqa: disable=all
alter role anon set pgrst.db_root_spec = 'api.root';

alter role authenticated set pgrst.db_root_spec = 'api.root';

alter role service_role set pgrst.db_root_spec = 'api.root';
-- noqa: enable=all

create function api.root() returns jsonb
    language plpgsql
    immutable set search_path = '' as $$
begin
    return '{
      "swagger": "2.0",
      "info": {
        "title": "Private API",
        "version": "1.0.0",
        "description": "This API is not publicly documented."
      },
      "paths": {}
    }'::jsonb;
end; $$;

grant execute on function api.root () to anon, authenticated, service_role;
-- noqa: disable=all
alter role anon set pgrst.db_root_spec = 'api.root';

alter role authenticated set pgrst.db_root_spec = 'api.root';

alter role service_role set pgrst.db_root_spec = 'api.root';
-- noqa: enable=all

Supabase update OpenAPI access

Similar Threads

Supabase update OpenAPI access

Similar Threads

Similar Threads

Similar Threads