ways to restrict data
Is there a way to restrict data at table level across schema.
i have 500 tables spread across 100 schemas, how do i limit the data for all tables across one shot.
i dont want to go to each table level and apply filter. can we create a session variable and use it inside table query? is that possible?
@Ram -- are you talking about applying security to the SQL that extracts data from your source systems like Amit addressed below? Or are you talking about applying security to your 500 Incorta tables? If the latter, keep in mind that your only have to define your security filters on the childmost tables. The security will be carried over to the parent tables from there.
Dan Brock , can you elaborate more on this? I'm implementing RLS and CLS right now for a client, and they have direct SQL on top of schema views, extracting information at many different levels - essentially duplicating data through data wrangling.
In essence, are you saying that if I apply CLS/RLS at the child most tables, that even the SQL applied to them in other schemas will have the same security filters applied?