as always I'm late to the party. I'm Charlie from Austria and have been
working with Exasol as our core data warehouse for the past 5 years. In
the past I've managed DB2 Mainframe, DB2 LUW, MariaDB and various data
related tools (Datastage, SAP BI, ....
not true for all cases 😉 /* snapshot execution */ SELECT edu.USER_NAME,
edrp.GRANTED_ROLE , EDRp.ADMIN_OPTION FROM sys.EXA_DBA_USERS edu INNER
JOIN sys.EXA_DBA_ROLE_PRIVS edrp ON edu.USER_NAME = edrp.GRANTEE INNER
JOIN SYS.EXA_DBA_OBJ_PRIVS edop ON ...
Hi, we did not yet run into problems however we have not that much
different schemas ~ 250 Schemas ~ 8000 Tables ~ 181k Columns ~ 2000
Users This is not the a problem in any way however we automatically
generate roles for every object and schema to b...
It highly depends on the privileges of the owner role of the schema as
the user will always inherit these rights. So you can't use an owner
role that has high privileges on a schema but if you want to have a
dedicated schema for these user defined vi...
Hi, you can upload the backup files into the new archive volume either
bei using ftp or curl curl --ftp-ssl --insecure --user admin:
--upload-file ftp://:2021// Example: curl --ftp-ssl --insecure --user
admin:admin --upload-file metadata_202011120856...