Thread: Packages?
Hi, Is there chance we will get packages (like those in Oracle) in PostgreSQL? They are kind of nice to have. The main advantage from my point of view is the ability to grant execute to a single package to a user and then they can run all procedures in the package.
Hi
pá 13. 11. 2020 v 8:29 odesílatel Post Gresql <postgresql@taljaren.se> napsal:
Hi,
Is there chance we will get packages (like those in Oracle) in PostgreSQL?
This probability is very low - Postgres has redundant feature - schema. Schema (in Postgres) can be used like Oracle's packages. Orafce uses schemas instead packages well.
They are kind of nice to have. The main advantage from my point of view
is the ability to grant execute to a single package to a user and then
they can run all procedures in the package.
Without usage right nobody can use function or procedure from schema.
Regards
Pavel