Module: PgRls::Database::Prepared
- Defined in:
- lib/pg_rls/database/prepared.rb
Overview
Prepare database for test unit
Class Method Summary collapse
Class Method Details
.grant_user_credentials(name: PgRls.username, schema: 'public') ⇒ Object
8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 |
# File 'lib/pg_rls/database/prepared.rb', line 8 def grant_user_credentials(name: PgRls.username, schema: 'public') PgRls.admin_execute <<-SQL.squish DO $do$ BEGIN IF NOT EXISTS ( SELECT table_catalog, table_schema, table_name, privilege_type FROM information_schema.table_privileges WHERE grantee = '#{name}' ) THEN GRANT ALL PRIVILEGES ON TABLE schema_migrations TO #{name}; GRANT USAGE ON SCHEMA #{schema} TO #{name}; ALTER DEFAULT PRIVILEGES IN SCHEMA #{schema} GRANT USAGE, SELECT ON SEQUENCES TO #{name}; ALTER DEFAULT PRIVILEGES IN SCHEMA #{schema} GRANT SELECT, INSERT, UPDATE, DELETE ON TABLES TO #{name}; GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA #{schema} TO #{name}; GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA #{schema} TO #{name}; END IF; END; $do$; SQL end |