Обсуждение: Restricting access to SHOW/SET

This cannot be done, and wouldn't be a complete solution even if it could.

The configuration of, and all object definitions in, the database are considered public knowledge in PostgreSQL.  Only table contents and the capability to execute functions/procedures are secured - either directly or, as a convenience method, by restricting access to the schema in which they are contained.

David J.