What command will grant the SELECT privilege on all new tables created in the mydb.myschema schema to the read_only role?
GRANT SELECT ON ALL TABLES IN SCHEMA mydb.myschema TO ROLE read_only;
GRANT USAGE ON FUTURE SCHEMAS IN DATABASE mydb TO ROLE read_only;
GRANT SELECT ON FUTURE TABLES IN SCHEMA mydb.myschema TO ROLE read_only;
GRANT USAGE ON ALL SCHEMAS IN DATABASE mydb TO ROLE read_only;
Submit