Securing Extension

Securing Extension

  

Hi all,

is there any way we can restrict a particular extension to be used by other applications ?

My DB is SQL Server and I have created and extension to use external tables of oracle DB. Now that extension is exposed in server and all its entities can be viewed and used by all other applications.

But i want to restrict the usage of that extension to a particular application as the table data are crucial.

Is there any way to restrict its use ?

In short: no.


However, you could do something with lifetime-roles so not everybody can access certain applications etc.

Perhaps with some runtime permisson etc.


It's a known "issue" because i would REALLY love some sort of friend-encapsulation.



well, in lifetime we can grant roles to applications but since the extensions are public, they can still be used.