How to allow CREATE/DROP CATALOG with file-based access control? #27139
-
|
Hi, I'd like to be able to run
{
"catalogs": [
{
"user": "admin",
"allow": "all"
},
{
"user": "employee",
"allow": "read-only"
}
],
"tables": [
{
"user": "admin",
"privileges": [
"SELECT",
"INSERT",
"DELETE",
"UPDATE",
"OWNERSHIP",
"GRANT_SELECT"
]
},
{
"user": "employee",
"table": "employees",
"privileges": [
"SELECT"
],
"filter": "department = 'Engineering'"
}
]
}I connect with: Everything works as expected, but if I try to run a command like |
Beta Was this translation helpful? Give feedback.
Replies: 1 comment
-
|
The |
Beta Was this translation helpful? Give feedback.
The
allowkey needs to be set toownerinstead ofall. Found in #22022. I think https://trino.io/docs/current/security/file-system-access-control.html#catalog-rules could be updated to reflect that.