Hi, team.
For loading data into Starrocks via Fli...
# questions-and-troubleshootingt
Tiasnu
09/30/2025, 12:19 PMHi, team.
For loading data into Starrocks via Flink connector, what kind of user role permissions need to be set? I have created the following role and granted the user for Flink
Copy code
GRANT SELECT, INSERT, UPDATE, DELETE ON <database>.* TO ROLE '<database>_writer';
GRANT '<database>_writer' TO '<user>';
SET DEFAULT ROLE '<database>_writer' TO '<user>'; Copy code
java.lang.IllegalArgumentException: Failed to get table schema info from StarRocks. Access denied for user '<user>' (using password: YES)h
Huguette Sandrine
09/30/2025, 3:11 PMHave you tried starting with a user that has elevated privileges just like the root? If you are still in development env. From there, you can start removing a few privileges while testing to see which one works and which one once removed causes the errror.
t
Tiasnu
09/30/2025, 5:16 PMI have already tested using root user and admin user creds, that's not the issue here. For production, the current setup is not possible, and nowhere in the documentation, there's any clarification on what exactly the permissions needed for the Flink connector itself. (The doc has mentioned, SELECT and INSERT should be granted for the user)
Tiasnu
09/30/2025, 5:18 PMIn terms of "removing previleges" I dont see how that is possible, since the only two things granted to the working version of the Flink connector user is
• db_admin
• user_admin
I dont see how one can test removing priviledges from there
h
Huguette Sandrine
09/30/2025, 5:19 PMWhen is this error raised? The command you are running that raises this error. Is it when you run the job with sql-client script?
t
Tiasnu
09/30/2025, 5:21 PMThis error is raised from Flink sql-gateway, before the job was sent to job manager
Tiasnu
09/30/2025, 5:21 PMI have tried to add
Copy code
GRANT SELECT ON information_schema.tables to ROLE '<database>_writer';
GRANT SELECT ON information_schema.columns to ROLE '<database>_writer';Tiasnu
10/10/2025, 7:07 AMThe issue was that I was quoting a wrong password, instead of access issues. Somehow starrocks gives a AuthZ error, which should have been an Auth0 error