rckrdmrd
50a821a415
- HERENCIA-SIMCO.md actualizado con directivas v3.7 y v3.8 - Actualizaciones de configuracion Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
19 lines
676 B
SQL
19 lines
676 B
SQL
-- ============================================
|
|
-- TEMPLATE-SAAS: WhatsApp Schema
|
|
-- Version: 1.0.0
|
|
-- ============================================
|
|
|
|
-- Create schema
|
|
CREATE SCHEMA IF NOT EXISTS whatsapp;
|
|
|
|
-- Grant permissions
|
|
GRANT USAGE ON SCHEMA whatsapp TO template_saas_app;
|
|
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA whatsapp TO template_saas_app;
|
|
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA whatsapp TO template_saas_app;
|
|
|
|
-- Default privileges for future tables
|
|
ALTER DEFAULT PRIVILEGES IN SCHEMA whatsapp
|
|
GRANT ALL PRIVILEGES ON TABLES TO template_saas_app;
|
|
ALTER DEFAULT PRIVILEGES IN SCHEMA whatsapp
|
|
GRANT ALL PRIVILEGES ON SEQUENCES TO template_saas_app;
|