trinodb / trino

Official repository of Trino, the distributed SQL query engine for big data, formerly known as PrestoSQL (https://trino.io)
https://trino.io
Apache License 2.0
10.51k stars 3.03k forks source link

Configuring multiple access-control.properties in config.properties does not take effect #20152

Open A-little-bit-of-data opened 11 months ago

A-little-bit-of-data commented 11 months ago

According to the document description, multiple files were configured, as shown in the figure below. After restarting the coordinator, it was found that it did not take effect through the trino-cli connection, but it was shown in the log that it took effect. image image image image

But if you write only one property in the access-control.config-files in the config.properties file, and verify that the configuration takes effect through trino-cli query, has anyone encountered this situation? Or is there something wrong with my configuration?

### Tasks
hirolee88 commented 11 months ago

What UI are you using? The issue is, there's Trino-admin on the left side, but results not, right?

What is the content of test.json?

A-little-bit-of-data commented 11 months ago

What UI are you using? The issue is, there's Trino-admin on the left side, but results not, right?

What is the content of test.json?

ui is superset, and Trino-admin represents the user who uses admin. The results on the right should see all catalogs, but only one system is seen. The content of test.json is as follows:

{ "catalogs": [ { "user": "tpcds", "catalog": "tpcds", "allow": "all" } ], "schemas": [ { "user": "tpcds", "catalog": "tpcds", "schema": "sf1|sf10", "owner": false } ], "tables": [ { "catalog": "tpcds", "schema": "sf1|sf10", "user": "tpcds", "table": ".*", "privileges": [ "SELECT", "INSERT", "DELETE", "UPDATE", "OWNERSHIP", "GRANT_SELECT" ] } ] }

A-little-bit-of-data commented 11 months ago

Has anyone encountered this problem before?

A-little-bit-of-data commented 7 months ago

The problem has been raised for several months. Hasn't the official noticed this problem?