IDOL_CHECK_ACL

Checks the access control list to verify that the user has permissions to access the data in the IDOL flex table and any views created from the table.

Syntax

v_idol.idol_check_acl(autonomymetadata,securitysection, securitytype  using parameters
sis='MTMyfNudFzPXVB5rX2dLnU89CQo+B668H6iNiHril4KPC+ptoA4x8OKzefMme/y3QNYzQs+QVMd7nmvPc4CaT9qxNr3t2EMgr8YNGJ5KKnE6lYN4BixkKd24ltEN1LZ08c
CJXiQaTppIqayD8UI9aC+JVVtGxeycO03cqrvQiMMqxzmrHEQfw==') from v_idol.idolsecurity; 

You can also use the session parameter as part of the syntax:

Alter session set UDPARAMETER FOR v_idol.IdolLib IdolSecurityInfo ='MTMyf ... <encrypted SIS> ...BCmky';
SELECT v_idol.idol_check_acl(acl, security_section, security_type) from v_idol.t;

Privileges

To run idol_check_acl on a view, you must be granted access to the view by the database administration user. This example creates a table, creates a view from the table, and grants access to the view to user1:

=> CREATE TABLE idoldata_base(…);
=> CREATE VIEW idoldata as select * from idoldata_base where idol_check_acl(…);
=> GRANT SELECT ON idoldata to user1;

Returns

This function returns one of the following: