I am trying to grant FILE WRITE and OUTBOUND privileges to a user on my Singlestore cluster. The GRANT query I am executing is:
GRANT FILE WRITE, OUTBOUND ON `the_database`.`*` TO 'user1'@'%'
I am executing the above command as an admin user - the first user I set up when creating singlestore and I am getting the following error:
SQL Error  : Forwarding Error (node-2aa6f46a-6174-47f0-bced-508c8a25a0f4-master-0.svc-2aa6f46a-6174-47f0-bced-508c8a25a0f4:3306): Access denied for user 'admin'@'%' to database 'the_database'
What am I doing wrong?