From DBeaver, how to filter system schemas (ie: starting with "%") ?
I'm looking for an efficient way in DBeaver to filter system tables (ex: belonging to a schema starting with "%").
By using a user with the %All role, DBeaver shows us a long list of system schemas, which forces us to go down the list before accessing the user tables.
.png)
By creating a user in IRIS with restricted rights, this list can be reduced, but the interest of the %All role is lost.
Comments
The solution is to use the Schemas / Usersfilters in the connection settings :
.png)
And adding "%" in the "to exclude" part :
.png)
Actually excluding all the "%" schemas in the connection setting is not working properly as it masks all the schemas' names. You have directly the names of all the tables and when you try to open it, you get an error as the query use SQLUser as the default schema.
I think we still need deeper support for IRIS in DBeaver, and it can be implemented.
So it will be possible to have more options to be configured, and more possibilities
I agree.
Filtering "schemas / users" by excluding "%" it not working very well indeed as it masks all the schemas' names and then considers all the tables in the "SQLUser" default schema...
You can explicitly exclude '%' schemas with the pattern "\%*" in the Exclude list:
.png)
Thank you @Jeffrey Drumm
I missed the correct syntax !
Alternative approach: create a user which has access only to schemas you need.
This was typically my first thinking when I said "by creating a user in IRIS with restricted rights, this list can be reduced, but the interest of the %All role is lost."