Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- exec { "Set default privileges fot TABLES":
- command => "export PGPASSWORD=$rds_role_admin_password && psql -h sitlrds -U $rds_role_admin -d $rds_database -c 'ALTER DEFAULT PRIVILEGES FOR ROLE lsradmin IN SCHEMA public GRANT ALL PRIVILEGES ON TABLES to lsrpublic;'",
- unless => "export PGPASSWORD=$rds_role_public_password && psql -h sitlrds -U $rds_role_public -d $rds_database -c 'select * from passportreport;'",
- }
- exec { "Set default privileges fot SEQUENCES":
- command => "export PGPASSWORD=$rds_role_admin_password && psql -h sitlrds -U $rds_role_admin -d $rds_database -c 'ALTER DEFAULT PRIVILEGES FOR ROLE lsradmin IN SCHEMA public GRANT ALL PRIVILEGES ON SEQUENCES to lsrpublic;'",
- unless => "export PGPASSWORD=$rds_role_public_password && psql -h sitlrds -U $rds_role_public -d $rds_database -c 'select * from passportreport;'",
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement