role/user management

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

role/user management

Kirti Adesara
Hi

I have a database with multiple tables, functions and triggers in public schema.

I want to create a user that can login to database and select on specific tables and cannot access to any functions, triggers and specific tables.

Thanks,

Kirti



ADESARA KIRTI D.
+91-98257-45997
Reply | Threaded
Open this post in threaded view
|

Re: role/user management

Joe Conway
On 5/4/19 12:44 PM, Kirti Adesara wrote:
> I have a database with multiple tables, functions and triggers in public
> schema.
>
> I want to create a user that can login to database and select on
> specific tables and cannot access to any functions, triggers and
> specific tables.

You haven't asked any questions -- please read the fine manual and them
come back with specific questions and you will be much more likely to
get help.

As a starting point, see:

  https://www.postgresql.org/docs/11/sql-grant.html

-and-

  https://wiki.postgresql.org/wiki/Guide_to_reporting_problems

HTH,

Joe

--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development


signature.asc (849 bytes) Download Attachment