Hi,
Is it possible to add object security rules on a _R table from within TimeXtender?
Thx!
Best answer by Christian Hauggaard
View originalObject Security for Raw table (_R)
Userlevel 3
+1
Userlevel 5
+7
Hi,
what is the use case you are trying to achieve? _R tables are really just internal technical tables.
Userlevel 3
+1
Hi Rory,
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.
Userlevel 5
+7
Hi,
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.
Userlevel 6
+5
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
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
