How can I get a list of all the RBS (row-based security) procedures?
Article ID: KB0082918
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | 7.0.0 and higher |
Description
This article discusses how to obtain a list of all Row-Based Security (RBS) procedures.
Issue/Introduction
How can I get a list of all the RBS (row-based security) procedures?
Resolution
When you create a free form Row-Based security policy, an RBS (Row-Based Security) procedure is created. The purpose of the procedure is to impose security restrictions on SQL statements. To get a list of all RBS procedures, run the following query in Studio Scratchpad:
SELECT
*
FROM
/services/databases/system/ALL_RESOURCES
WHERE
ANNOTATION like 'Row Level%'
SELECT
*
FROM
/services/databases/system/ALL_RESOURCES
WHERE
ANNOTATION like 'Row Level%'
Feedback
Yes
No
Powered by
