mDcjQWRN

1CREATE ROLE myOrgId6171 NOINHERIT NOLOGIN;
2CREATE SCHEMA myOrgId6171;
3ALTER ROLE myOrgId6171 SET search_path TO myOrgId6171;
4CREATE TABLE IF NOT EXISTS myOrgId6171.testtable6171 (bleh integer);
5ALTER TABLE myOrgId6171.testtable6171 OWNER TO myOrgId6171;
6GRANT ALL ON SCHEMA myOrgId6171 TO myOrgId6171;
7
8BEGIN;
9SET LOCAL ROLE myOrgId6171;
10select * from testtable6171;
11COMMIT;