altef commented on issue #8644: [SIP-29] Add support for row-level security
URL: 
https://github.com/apache/incubator-superset/issues/8644#issuecomment-559903928
 
 
   Essentially, we're giving each role access to a subset of the table.  So we 
could have one role: **Company A**, who has the clause `company_id=12`
   And another role: **Last 30 days**, who has the clause `date_field > 
DATE_SUB(NOW(), INTERVAL 30 DAY)`
   
   And for a specific user of **Company A**, if they should only be able to see 
the last 30 days worth of data, apply both roles.
   
   Since a row level security filter's clause is arbitrary, it can also support 
multiple conditions: `client_id = 6 AND advertiser="foo"`, etc.  You can throw 
whatever you want in there to define the subset of the table you want the role 
in question to have access to.

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
[email protected]


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to