Azure Database
Requirements
Integration
1
2
CREATE USER teleskope IDENTIFIED BY '****PASSWORD****'CREATE USER teleskope WITH PASSWORD '****PASSWORD****'3
GRANT SHOW DATABASES, SELECT ON *.* TO teleskopeGRANT pg_read_all_data TO teleskopeSELECT format('GRANT CONNECT ON DATABASE %I TO teleskope;', datname) FROM pg_database \gexec
SELECT format('GRANT USAGE ON SCHEMA %I TO teleskope;', nspname) FROM pg_namespace \gexec
SELECT format('GRANT SELECT ON ALL TABLES IN SCHEMA %I TO teleskope;', nspname) FROM pg_namespace \gexec4
GRANT UPDATE, DELETE on *.* TO teleskopeGRANT pg_write_all_data TO teleskopeSELECT format('GRANT UPDATE, DELETE ON ALL TABLES IN SCHEMA %I TO teleskope;', nspname)Last updated
Was this helpful?
