Oracle 12C Accessible by clause

[@premgona5587]

Thanks for the new topic which I'm not aware of... I have a silly question When I do as below ACCESSIBLE BY(EMP_LIST); What would be EMP_LIST? Is it a procedure or function or package or triigger or type ?

[@SivaAcademy]

The unit type you can mention in ACCESSIBLE BY clause can be "FUnction", "Procedure", "package", "Trigger" and "Type". More details for your reference at docs.oracle.com/en/database/oracle/oracle-database/12.2/lnpls/ACCESSIBLE-BY-clause.html#GUID-9720619C-9862-4123-96E7-3E85F240FF36

[@ramkumarj4216]

@@SivaAcademy Is it possible to provide n number of values( proc, function etc..) in accessible by clause

[@lalatendupradhan525]

@@ramkumarj4216 yes

[@robh115]

Thanks for the video. How is this different than object grants?

[@patinoricardo]

Genial, gracias por difundir.

[@SivaAcademy]

Bienvenido, gracias por tus comentarios