From: Joe Conway <mail@joeconway.com>
To: Kirti Adesara <kdadesara@hotmail.com>
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: role/user management
Date: Sat, 4 May 2019 13:56:51 -0400
Message-ID: <868fbb69-cf40-d946-df38-d25de9d0b472@joeconway.com> (raw)
In-Reply-To: <HK2PR0302MB2595781868858B677AD999EEA1360@HK2PR0302MB2595.apcprd03.prod.outlook.com>
References: <HK2PR0302MB2595781868858B677AD999EEA1360@HK2PR0302MB2595.apcprd03.prod.outlook.com>
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
Attachments:
signature.asc (application/pgp-signature, 832B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: mail@joeconway.com, kdadesara@hotmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: role/user management
In-Reply-To: <868fbb69-cf40-d946-df38-d25de9d0b472@joeconway.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox