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.
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 other privileges that you do not need to map, such as CREATE TRIGGER).
- For an overview of users and roles, see Appendix E.
- For information about access rights in Teradata, see Access Rights Codes
- For information about access rights in Exasol, see Details on Rights Management
- For information on row level security, see Row Level Security on GitHub.
