93ecc1a6f8
Some checks failed
✅ Check / 🔬 ESLint (push) Failing after 21s
✅ Check / 🏷️ Typecheck (push) Failing after 11s
✅ Check / 🔎 Test (push) Failing after 11s
✅ Check / e2e-test (push) Failing after 11s
✅ Check / 🔨 Build (push) Failing after 11s
🚀 Deploy / 🚀 Deploy (doc) (push) Failing after 12s
🚀 Deploy / 🚀 Deploy (demo) (push) Failing after 12s
🚀 Deploy / 🚀 Deploy (supabase) (push) Failing after 18s
178 lines
8.1 KiB
SQL
178 lines
8.1 KiB
SQL
--
|
|
-- Grants
|
|
-- This file declares all grants and default privileges for the public schema.
|
|
--
|
|
|
|
-- Schema usage
|
|
grant usage on schema public to postgres;
|
|
grant usage on schema public to anon;
|
|
grant usage on schema public to authenticated;
|
|
grant usage on schema public to service_role;
|
|
|
|
-- Function grants
|
|
grant all on function public.cleanup_note_attachments() to anon;
|
|
grant all on function public.cleanup_note_attachments() to authenticated;
|
|
grant all on function public.cleanup_note_attachments() to service_role;
|
|
|
|
grant all on function public.get_avatar_for_email(text) to anon;
|
|
grant all on function public.get_avatar_for_email(text) to authenticated;
|
|
grant all on function public.get_avatar_for_email(text) to service_role;
|
|
|
|
grant all on function public.get_domain_favicon(text) to anon;
|
|
grant all on function public.get_domain_favicon(text) to authenticated;
|
|
grant all on function public.get_domain_favicon(text) to service_role;
|
|
|
|
grant all on function public.get_note_attachments_function_url() to anon;
|
|
grant all on function public.get_note_attachments_function_url() to authenticated;
|
|
grant all on function public.get_note_attachments_function_url() to service_role;
|
|
|
|
revoke all on function public.get_user_id_by_email(text) from public;
|
|
grant all on function public.get_user_id_by_email(text) to service_role;
|
|
|
|
grant all on function public.handle_company_saved() to anon;
|
|
grant all on function public.handle_company_saved() to authenticated;
|
|
grant all on function public.handle_company_saved() to service_role;
|
|
|
|
grant all on function public.handle_contact_note_created_or_updated() to anon;
|
|
grant all on function public.handle_contact_note_created_or_updated() to authenticated;
|
|
grant all on function public.handle_contact_note_created_or_updated() to service_role;
|
|
|
|
grant all on function public.handle_contact_saved() to anon;
|
|
grant all on function public.handle_contact_saved() to authenticated;
|
|
grant all on function public.handle_contact_saved() to service_role;
|
|
|
|
grant all on function public.handle_new_user() to anon;
|
|
grant all on function public.handle_new_user() to authenticated;
|
|
grant all on function public.handle_new_user() to service_role;
|
|
|
|
grant all on function public.handle_update_user() to anon;
|
|
grant all on function public.handle_update_user() to authenticated;
|
|
grant all on function public.handle_update_user() to service_role;
|
|
|
|
grant all on function public.is_admin() to anon;
|
|
grant all on function public.is_admin() to authenticated;
|
|
grant all on function public.is_admin() to service_role;
|
|
|
|
grant all on function public.lowercase_email_jsonb() to anon;
|
|
grant all on function public.lowercase_email_jsonb() to authenticated;
|
|
grant all on function public.lowercase_email_jsonb() to service_role;
|
|
|
|
grant all on function public.merge_contacts(bigint, bigint) to anon;
|
|
grant all on function public.merge_contacts(bigint, bigint) to authenticated;
|
|
grant all on function public.merge_contacts(bigint, bigint) to service_role;
|
|
|
|
grant all on function public.set_sales_id_default() to anon;
|
|
grant all on function public.set_sales_id_default() to authenticated;
|
|
grant all on function public.set_sales_id_default() to service_role;
|
|
|
|
-- Table grants
|
|
grant all on table public.companies to anon;
|
|
grant all on table public.companies to authenticated;
|
|
grant all on table public.companies to service_role;
|
|
|
|
grant all on table public.contacts to anon;
|
|
grant all on table public.contacts to authenticated;
|
|
grant all on table public.contacts to service_role;
|
|
|
|
grant all on table public.contact_notes to anon;
|
|
grant all on table public.contact_notes to authenticated;
|
|
grant all on table public.contact_notes to service_role;
|
|
|
|
grant all on table public.deals to anon;
|
|
grant all on table public.deals to authenticated;
|
|
grant all on table public.deals to service_role;
|
|
|
|
grant all on table public.deal_notes to anon;
|
|
grant all on table public.deal_notes to authenticated;
|
|
grant all on table public.deal_notes to service_role;
|
|
|
|
grant all on table public.sales to anon;
|
|
grant all on table public.sales to authenticated;
|
|
grant all on table public.sales to service_role;
|
|
|
|
grant all on table public.tags to anon;
|
|
grant all on table public.tags to authenticated;
|
|
grant all on table public.tags to service_role;
|
|
|
|
grant all on table public.tasks to anon;
|
|
grant all on table public.tasks to authenticated;
|
|
grant all on table public.tasks to service_role;
|
|
|
|
grant all on table public.configuration to anon;
|
|
grant all on table public.configuration to authenticated;
|
|
grant all on table public.configuration to service_role;
|
|
|
|
grant all on table public.favicons_excluded_domains to anon;
|
|
grant all on table public.favicons_excluded_domains to authenticated;
|
|
grant all on table public.favicons_excluded_domains to service_role;
|
|
|
|
-- View grants
|
|
grant all on table public.activity_log to anon;
|
|
grant all on table public.activity_log to authenticated;
|
|
grant all on table public.activity_log to service_role;
|
|
|
|
grant all on table public.companies_summary to anon;
|
|
grant all on table public.companies_summary to authenticated;
|
|
grant all on table public.companies_summary to service_role;
|
|
|
|
grant all on table public.contacts_summary to anon;
|
|
grant all on table public.contacts_summary to authenticated;
|
|
grant all on table public.contacts_summary to service_role;
|
|
|
|
grant all on table public.init_state to anon;
|
|
grant all on table public.init_state to authenticated;
|
|
grant all on table public.init_state to service_role;
|
|
|
|
-- Sequence grants
|
|
grant all on sequence public.companies_id_seq to anon;
|
|
grant all on sequence public.companies_id_seq to authenticated;
|
|
grant all on sequence public.companies_id_seq to service_role;
|
|
|
|
grant all on sequence public."contactNotes_id_seq" to anon;
|
|
grant all on sequence public."contactNotes_id_seq" to authenticated;
|
|
grant all on sequence public."contactNotes_id_seq" to service_role;
|
|
|
|
grant all on sequence public.contacts_id_seq to anon;
|
|
grant all on sequence public.contacts_id_seq to authenticated;
|
|
grant all on sequence public.contacts_id_seq to service_role;
|
|
|
|
grant all on sequence public."dealNotes_id_seq" to anon;
|
|
grant all on sequence public."dealNotes_id_seq" to authenticated;
|
|
grant all on sequence public."dealNotes_id_seq" to service_role;
|
|
|
|
grant all on sequence public.deals_id_seq to anon;
|
|
grant all on sequence public.deals_id_seq to authenticated;
|
|
grant all on sequence public.deals_id_seq to service_role;
|
|
|
|
grant all on sequence public.favicons_excluded_domains_id_seq to anon;
|
|
grant all on sequence public.favicons_excluded_domains_id_seq to authenticated;
|
|
grant all on sequence public.favicons_excluded_domains_id_seq to service_role;
|
|
|
|
grant all on sequence public.sales_id_seq to anon;
|
|
grant all on sequence public.sales_id_seq to authenticated;
|
|
grant all on sequence public.sales_id_seq to service_role;
|
|
|
|
grant all on sequence public.tags_id_seq to anon;
|
|
grant all on sequence public.tags_id_seq to authenticated;
|
|
grant all on sequence public.tags_id_seq to service_role;
|
|
|
|
grant all on sequence public.tasks_id_seq to anon;
|
|
grant all on sequence public.tasks_id_seq to authenticated;
|
|
grant all on sequence public.tasks_id_seq to service_role;
|
|
|
|
-- Default privileges
|
|
alter default privileges for role postgres in schema public grant all on sequences to postgres;
|
|
alter default privileges for role postgres in schema public grant all on sequences to anon;
|
|
alter default privileges for role postgres in schema public grant all on sequences to authenticated;
|
|
alter default privileges for role postgres in schema public grant all on sequences to service_role;
|
|
|
|
alter default privileges for role postgres in schema public grant all on functions to postgres;
|
|
alter default privileges for role postgres in schema public grant all on functions to anon;
|
|
alter default privileges for role postgres in schema public grant all on functions to authenticated;
|
|
alter default privileges for role postgres in schema public grant all on functions to service_role;
|
|
|
|
alter default privileges for role postgres in schema public grant all on tables to postgres;
|
|
alter default privileges for role postgres in schema public grant all on tables to anon;
|
|
alter default privileges for role postgres in schema public grant all on tables to authenticated;
|
|
alter default privileges for role postgres in schema public grant all on tables to service_role;
|