Hide EXA_STATISTICS and SYS schemas

drumcircle
SQL-Fighter

Building a multi-tenant app and have disabled public access to schemas per docs.

revoke use any schema from public;

Why is it then that I can still see EXA_STATISTICS and SYS schemas?  This will be confusing for my end-users.  Can they be suppressed as well?

drumcircle_0-1608051335556.png

 

1 ACCEPTED SOLUTION

exa-Nico
Community Manager
Community Manager

Every user is able to access the system schemas because they are able to see at least a subset of the data there (such as their user information, sessions, tables that contain EXA_ALL_. So I don't think it's possible to hide them completely. Many database browsers will put them in a separate category (for example DBVisualizer puts it under "System Schemas" instead of just "Schemas"), but I'm not if it is possible to do this in Tableau. 

Sports Enthusiast. Database Guy. Member of Team Exasol.
Having trouble? Just let me know!

Please Give Kudos if you find this post useful and also mark this as Accepted Solution if this is the required solution

View solution in original post

3 REPLIES 3

exa-Nico
Community Manager
Community Manager

Every user is able to access the system schemas because they are able to see at least a subset of the data there (such as their user information, sessions, tables that contain EXA_ALL_. So I don't think it's possible to hide them completely. Many database browsers will put them in a separate category (for example DBVisualizer puts it under "System Schemas" instead of just "Schemas"), but I'm not if it is possible to do this in Tableau. 

Sports Enthusiast. Database Guy. Member of Team Exasol.
Having trouble? Just let me know!

Please Give Kudos if you find this post useful and also mark this as Accepted Solution if this is the required solution

View solution in original post

skarangi
SQL-Fighter

Which version of exasol are you using? I think that might be the reason.  Please see the release notes of 6.2 version

Hide inaccessible schemas
Starting with Exasol version 6.2, a user can only access a schema or virtual schema if the user is owner or if the user has an object or system privilege.

drumcircle
SQL-Fighter

I'm using 7.x latest AMI.

The user has one single system privilege: CREATE SESSION

No roles, no owned schemas... just...

 

GRANT USAGE ON  “VSX” TO "USERX"

GRANT SELECT ON  "VSX" TO "USERX"