Advertisement
Guest User

Untitled

a guest
Mar 20th, 2021
52
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. set setts.usr to :username;
  2. set setts.dev to :dev;
  3. set setts.db to :db;
  4.  
  5. create database :db;
  6. create user :username;
  7.  
  8. grant all privileges on database setts.db to setts.usr;
  9.  
  10. DO $$
  11. declare
  12. username text := current_setting('setts.usr');
  13. dev      integer := current_setting('setts.dev');
  14. begin
  15. if dev > 0 then
  16.     create database test_keystore;
  17.     grant all privileges on database test_keystore to username;
  18. end if;
  19. END $$
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement