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
Attachment:
signature.asc
Description: OpenPGP digital signature
