2

You can't get the original source back. DBA_SOURCE, ALL_SOURCE, and USER_SOURCE are data dictionary views. So you can do something like select line, text from user_source where name = 'GET_OS_USER' and type = 'FUNCTION'; That will show you the wrapped text of the function. But the point of wrapping your source code is to prevent users that have ...


1

Now my question is if my network team only allows only the Always on availability group listener port will that be a problem You can configure an AG Listener to use whatever port you want, and you can configure your application to connect using a non-standard port. what if the network team dont allow access to that port A "normal" DMZ has ...


1

The big security problem here is that it doesn't revoke execution on its created functions from PUBLIC, which means that users other than bluemedora can use them, which is evidently not what is intended. For pg_stat_statement this isn't really a problem, as it is located in a schema that no one else should have access to, but for explain_this it is in ...


Only top voted, non community-wiki answers of a minimum length are eligible