Skip to main content
Solved

Object Security for Raw table (_R)


sierd.zuiderveld
Contributor
Forum|alt.badge.img+1

Hi,

 

Is it possible to add object security rules on a _R table from within TimeXtender? 

 

Thx! 

Best answer by Christian Hauggaard

@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

 

View original
Did this topic help you find an answer to your question?

4 replies

rory.smith
TimeXtender Xpert
Forum|alt.badge.img+7
  • TimeXtender Xpert
  • 687 replies
  • February 8, 2023

Hi,

 

what is the use case you are trying to achieve? _R tables are really just internal technical tables.


sierd.zuiderveld
Contributor
Forum|alt.badge.img+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. 


rory.smith
TimeXtender Xpert
Forum|alt.badge.img+7
  • TimeXtender Xpert
  • 687 replies
  • February 9, 2023

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.


Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

@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

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings