# E081-08: WITH GRANT OPTION

onlyif Postgres
statement ok
CREATE TABLE TABLE_E081_08_01_011 ( A INT );
CREATE ROLE ROLE_E081_08_01_01;
GRANT SELECT ON TABLE TABLE_E081_08_01_011 TO ROLE_E081_08_01_01 WITH GRANT OPTION

onlyif Postgres
statement ok
CREATE TABLE TABLE_E081_08_01_021 ( A INT );
CREATE ROLE ROLE_E081_08_01_02;
GRANT SELECT ON TABLE_E081_08_01_021 TO ROLE_E081_08_01_02 WITH GRANT OPTION

onlyif Postgres
statement ok
CREATE TABLE TABLE_E081_08_02_011 ( A INT );
CREATE ROLE ROLE_E081_08_02_01;
GRANT DELETE ON TABLE TABLE_E081_08_02_011 TO ROLE_E081_08_02_01 WITH GRANT OPTION

onlyif Postgres
statement ok
CREATE TABLE TABLE_E081_08_02_021 ( A INT );
CREATE ROLE ROLE_E081_08_02_02;
GRANT DELETE ON TABLE_E081_08_02_021 TO ROLE_E081_08_02_02 WITH GRANT OPTION

onlyif Postgres
statement ok
CREATE TABLE TABLE_E081_08_03_011 ( A INT );
CREATE ROLE ROLE_E081_08_03_01;
GRANT INSERT ON TABLE TABLE_E081_08_03_011 TO ROLE_E081_08_03_01 WITH GRANT OPTION

onlyif Postgres
statement ok
CREATE TABLE TABLE_E081_08_03_021 ( A INT );
CREATE ROLE ROLE_E081_08_03_02;
GRANT INSERT ON TABLE_E081_08_03_021 TO ROLE_E081_08_03_02 WITH GRANT OPTION

onlyif Postgres
statement ok
CREATE TABLE TABLE_E081_08_04_011 ( A INT );
CREATE ROLE ROLE_E081_08_04_01;
GRANT UPDATE ON TABLE TABLE_E081_08_04_011 TO ROLE_E081_08_04_01 WITH GRANT OPTION

onlyif Postgres
statement ok
CREATE TABLE TABLE_E081_08_04_021 ( A INT );
CREATE ROLE ROLE_E081_08_04_02;
GRANT UPDATE ON TABLE_E081_08_04_021 TO ROLE_E081_08_04_02 WITH GRANT OPTION

onlyif Postgres
statement ok
CREATE TABLE TABLE_E081_08_05_011 ( A INT );
CREATE ROLE ROLE_E081_08_05_01;
GRANT UPDATE ( A ) ON TABLE TABLE_E081_08_05_011 TO ROLE_E081_08_05_01 WITH GRANT OPTION

onlyif Postgres
statement ok
CREATE TABLE TABLE_E081_08_05_021 ( A INT );
CREATE ROLE ROLE_E081_08_05_02;
GRANT UPDATE ( A ) ON TABLE_E081_08_05_021 TO ROLE_E081_08_05_02 WITH GRANT OPTION

onlyif Postgres
statement ok
CREATE TABLE TABLE_E081_08_06_011 ( A INT );
CREATE ROLE ROLE_E081_08_06_01;
GRANT REFERENCES ON TABLE TABLE_E081_08_06_011 TO ROLE_E081_08_06_01 WITH GRANT OPTION

onlyif Postgres
statement ok
CREATE TABLE TABLE_E081_08_06_021 ( A INT );
CREATE ROLE ROLE_E081_08_06_02;
GRANT REFERENCES ON TABLE_E081_08_06_021 TO ROLE_E081_08_06_02 WITH GRANT OPTION

onlyif Postgres
statement ok
CREATE TABLE TABLE_E081_08_07_011 ( A INT );
CREATE ROLE ROLE_E081_08_07_01;
GRANT REFERENCES ( A ) ON TABLE TABLE_E081_08_07_011 TO ROLE_E081_08_07_01 WITH GRANT OPTION

onlyif Postgres
statement ok
CREATE TABLE TABLE_E081_08_07_021 ( A INT );
CREATE ROLE ROLE_E081_08_07_02;
GRANT REFERENCES ( A ) ON TABLE_E081_08_07_021 TO ROLE_E081_08_07_02 WITH GRANT OPTION
