The Postgres development platform. Supabase gives you a dedicated Postgres database to build your web, mobile, and AI applications.
TypeScript aialternativeauthdatabasedenoembeddingsexamplefirebasenextjsoauth2pgvectorpostgispostgrespostgresqlpostgrestrealtimesupabasevectorswebsockets
import { safeSql, type SafeSqlFragment } from '../pg-format'
/**
* Relation ACLs (tables, views, matviews, foreign/partitioned). `scopeFilter`
* is a `safeSql` fragment starting with `and ` (or empty) on aliases `c`
* (pg_class) and `nc` (pg_namespace), applied before aclexplode / GROUP BY.
*/
export const getScopedTablePrivilegesSql = (
scopeFilter: SafeSqlFragment = safeSql``
): SafeSqlFragment => safeSql`
select
c.oid as relation_id,
nc.nspname as schema,
c.relname as name,
case
when c.relkind = 'r' then 'table'
when c.relkind = 'v' then 'view'
when c.relkind = 'm' then 'materialized_view'
when c.relkind = 'f' then 'foreign_table'
when c.relkind = 'p' then 'partitioned_table'
end as kind,
coalesce(
jsonb_agg(
jsonb_build_object(
'grantor', grantor.rolname,
'grantee', grantee.rolname,
'privilege_type', _priv.privilege_type,
'is_grantable', _priv.is_grantable
)
) filter (where _priv is not null),
'[]'
) as privileges
from pg_class c
join pg_namespace as nc
on nc.oid = c.relnamespace
left join lateral (
select grantor, grantee, privilege_type, is_grantable
from aclexplode(coalesce(c.relacl, acldefault('r', c.relowner)))
) as _priv on true
left join pg_roles as grantor
on grantor.oid = _priv.grantor
left join (
select
pg_roles.oid,
pg_roles.rolname
from pg_roles
union all
select
(0)::oid as oid, 'PUBLIC'
) as grantee (oid, rolname)
on grantee.oid = _priv.grantee
where c.relkind in ('r', 'v', 'm', 'f', 'p')
and not pg_is_other_temp_schema(c.relnamespace)
${scopeFilter}
and (
pg_has_role(c.relowner, 'USAGE')
or has_table_privilege(
c.oid,
'SELECT, INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER'
|| case when current_setting('server_version_num')::int4 >= 170000 then ', MAINTAIN' else '' end
)
or has_any_column_privilege(c.oid, 'SELECT, INSERT, UPDATE, REFERENCES')
)
group by
c.oid,
nc.nspname,
c.relname,
c.relkind
`