Controlling privileges in the data warehouse, especially with sensitive data, is an important part of data protection. While you can easily migrate users and roles for specific databases in Teradata, you need to map the rights to Exasol. See Appendix E for an overview of Users and Roles.
To find out more about the access rights, see the following:
- Teradata, see Access Rights Codes
- Exasol, see Details on Rights Management
Mapping existing access rights or user privileges from Teradata to Exasol can be tricky. While you can easily map to some privileges in Exasol, such as CREATE TABLE or CREATE VIEW, there are a few privileges that you do not need to map (for example, CREATE TRIGGER).
For information on row level security, see Row Level Security on GitHub.
