Users, Roles, and Rights

Every schema in Oracle is related to a corresponding user. Therefore, not every user needs to be migrated.

Users, Roles, and Rights

The rights management in Oracle covers indexes, tablespaces, materialized views, or ALTER PROCEDURE, for recompiling procedures in Oracle. These are not needed and therefore are not supported in Exasol. Most of the privileges for overlapping objects between Oracle and Exasol, such as tables and views, can be mapped easily.

In Oracle granting the right to select from all the tables within a schema to a user/role, requires grants on every individual table explicitly. This must be done for new tables as well as recreated/replaced tables.

GRANT SELECT ON "C##DB_MIG"."SALES" TO CORE_RO;
GRANT SELECT ON "C##DB_MIG"."STORES" TO CORE_RO;
GRANT SELECT ON "C##DB_MIG"."CUSTOMERS" TO CORE_RO;

This can be done on a schema level on Exasol, so that even future tables do not have to be manually included.

GRANT SELECT ON "C##DB_MIG" TO CORE_RO;

To check users, roles, and rights, see the following:

For more information on rights management in Exasol and Oracle, see the following links: