snowflake grants for create table

Question

I want to grant Create/Drop/Select/Insert/Delete/Truncate current & future table access to a role.

I did following still having problem.

grant usage on database TESTDB to role TEST_ROLE;
grant usage on schema TESTDB.TESTSCHEMA to role TEST_ROLE;
grant all on future tables in schema TESTDB.TESTSCHEMA to role TEST_ROLE;
grant all on all tables in schema TESTDB.TESTSCHEMA to role TEST_ROLE;

use role TEST_ROLE;
create table TESTDB.TESTSCHEMA.TESTTAB (name varchar(20);

SQL access control error: Insufficient privileges to operate on schema 'TESTSCHEMA'

Thanks

Answer 1

Creating a table is an action performed in the context of a schema. You need to use GRANT CREATE TABLE ON SCHEMA ...