Is it possible to add object security rules on a _R table from within TimeXtender?
Best answer by Christian Hauggaard 14 February 2023, 09:45
what is the use case you are trying to achieve? _R tables are really just internal technical tables.
This is a specific case for us and in general I try to avoid it.
We want a certain dashboard to read the raw table instead of the valid, due to some transformations that happen on the valid table that are not needed for this specific case.
Just recently we have switched to using the TimeXtender integrated security settings instead of another tool and I was just wondering if this setting is possible at all.
OK - I think branching off an unaltered version would be better, as far as I am aware you cannot use the security features on raw tables. You could of course take inspiration from how TX does it and roll your own.
@sierd.zuiderveld can you please try the steps below?
Add and deploy a new database schema
Then on the specific table go to table settings and set this new schema to be the raw schema for the table.
Then go to Object Security Setup under security
Select Schemas and select “add role” and then choose this role for the newly created schema
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.