create role/user management

Kirti Adesara <[email protected]> Sat, 4 May 2019 16:38:07 +0000
Newsgroups gmane.comp.db.postgresql.sql
Message-ID <HK2PR0302MB2595F89036B915D9E784E6A0A1360@HK2PR0302MB2595.apcprd03.prod.outlook.com>
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