Grant the required permissions to a service account and configure StarRocks as a data source for the scanner.
Service account authorization
-- Create user (if not exists)
CREATE USER '<username>' IDENTIFIED BY '<password>';
-- Grant permissions on default_catalog
GRANT USAGE ON CATALOG default_catalog TO USER '<username>';
GRANT SELECT ON ALL TABLES IN DATABASE default_catalog.<your_db> TO USER '<username>';
-- Grant permissions on external catalogs, such as hive_catalog and iceberg_catalog
GRANT USAGE ON CATALOG hive_catalog TO USER '<username>';
GRANT SELECT ON ALL TABLES IN DATABASE <hive_catalog>.<your_db> TO USER '<username>';
-- Grant access to the statistics database
GRANT SELECT ON DATABASE _statistics_ TO USER '<username>';Data source management
|
Option |
Description |
|
|
JDBC connection URL (Required) |
|
|
Username (Required) |
|
|
Password (Required) |
lhm datasource set StarRocks -n sr1 \
--jdbc-url jdbc:mysql://<host>:9030/<default> \
--username <username> \
--password '$DB_PASSWORD'