How to revoke access and list schema objects

From: "intmail01(at)gmail(dot)com" <intmail01(at)gmail(dot)com>
To: pgsql-sql(at)lists(dot)postgresql(dot)org
Subject: How to revoke access and list schema objects
Date: 2021-08-13 16:00:31
Message-ID: 56050f06-8382-07e5-19ce-261cb4ebdffc@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

There are are some people who use my database and I want to prevent them
to read code of tables and funtions. I have created a schema in which
only postgres user can have access. Other users can not use objects in
this but they can list all sql code for each object if they use pgadmin.
What is the command to prevent users to list objects and prevent them to
read the sql code.

Thanks

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Steve Midgley 2021-08-13 16:39:51 Re: Is there any way to invoke Java API from PostgreSQL
Previous Message Erik Brandsberg 2021-08-13 04:54:46 Re: Is there any way to invoke Java API from PostgreSQL