cassandra - cql: how can I grant a table that doesnt exist yet? -
i have user want grant create on keyspaces, , select on mykeyspace.table1.
the problem mykeyspace doesn't exist yet when granting, there option make work if mykeyspace wasn't created yet?
or should split granting 2 phases?
no, can't grant permission on resource not exist.
give below error
invalidrequest: code=2200 [invalid query] message="resource <keyspace mykeyspace> doesn't exist"
you can make user super user, can can have access new keyspace.
you can create super user below command :
create user test password 'test' superuser ;
or if have user can alter
alter user test superuser ;
Comments
Post a Comment