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:
t
- indicates the user has permission to access the data.f
- indicates the user does not have permission to access the data.