Arcadia Engine checks the user's authorization for analytical views, which makes the system secure.
Arcadia Engine uses the user's system privileges on objects (tables, databases, servers) to authorize access to analytical views.
For example, consider userA, who belongs to the groupA, which in turn has roleA. The analytical view av1 is based on table t. Then,
SELECT
privilege on table t, then whenever userA submits a query on t it will be routed to analytical view av1.SELECT
privilege on table t, userA will not be able to alter or insert into any analytical view based on table t. To do that, userA must have ALL
and INSERT
privileges.