mirror of
https://github.com/supabase/supabase.git
synced 2026-10-15 14:19:11 +03:00
Joshen Lim
d8a57c1c7e
* Add settings for queues: toggle expose through postgrest + permissions via table privileges * Ensure appropriate grants are granted when toggling, and revoked when disabling * Update to use queues_public schema * Update queue schema to pgmq_public and add/remove from data api when enabling/disabling * Fix query for retrieving toggle state * Add schema invalidation * Remove hard code * Use QueuesSettings from Queues folder, remove from NewQueues * Update SQL for toggling exposure + support RLS enabling * Support toggling RLS for a queue * Update admonition copy in queues for enabling/disable postgrest exposure * Add custom RLS policy for queue * Minor style fixes * Fix * Remove hard code * Update RLS to add message regarding relevancy only if exposure to PostgREST is enabled * Update message in exposing queues to postgREST * Address feedback * Address feedback * Don't revoke postgres role stuff * Remove hard code * Update copy * Update * Address Oli's feedback, ensure that queues ALL have RLS enabled prior to allowing exposure to PostgREST * Address remaining feedback * Remove hardcode * Update * Address feedback
29 lines
580 B
TypeScript
29 lines
580 B
TypeScript
import { QUEUES_SCHEMA } from 'data/database-queues/database-queues-toggle-postgrest-mutation'
|
|
|
|
/**
|
|
* A list of system schemas that users should not interact with
|
|
*/
|
|
export const PROTECTED_SCHEMAS = [
|
|
'auth',
|
|
'cron',
|
|
'extensions',
|
|
'information_schema',
|
|
'net',
|
|
'pgsodium',
|
|
'pgsodium_masks',
|
|
'pgbouncer',
|
|
'pgtle',
|
|
'realtime',
|
|
'storage',
|
|
'supabase_functions',
|
|
'supabase_migrations',
|
|
'vault',
|
|
'graphql',
|
|
'graphql_public',
|
|
QUEUES_SCHEMA,
|
|
]
|
|
|
|
export const PROTECTED_SCHEMAS_WITHOUT_EXTENSIONS = PROTECTED_SCHEMAS.filter(
|
|
(x) => x !== 'extensions'
|
|
)
|