agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Rob Sargent <robjsargent@gmail.com>
To: pgsql-sql@lists.postgresql.org
Subject: Re: create role/user management
Date: Mon, 6 May 2019 13:49:15 -0600
Message-ID: <906879c8-8e04-d436-ad7b-63ff057b1abb@gmail.com> (raw)
In-Reply-To: <CAKFQuwYVVHSRYv3BS8FfC==qYJRBZi1yU_JJ-XFW96Oqdspy7A@mail.gmail.com>
References: <HK2PR0302MB2595F89036B915D9E784E6A0A1360@HK2PR0302MB2595.apcprd03.prod.outlook.com>
<CAKFQuwYVVHSRYv3BS8FfC==qYJRBZi1yU_JJ-XFW96Oqdspy7A@mail.gmail.com>
On 5/6/19 1:43 PM, David G. Johnston wrote:
> On Sat, May 4, 2019 at 9:38 AM Kirti Adesara <kdadesara@hotmail.com
> <mailto:kdadesara@hotmail.com>> wrote:
>
> I have a database with multiple tables, functions and triggers in
> public schema.
>
>
> You should stop using the 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.
>
>
> Maybe provide an example what what is not presently working the way
> you expect and describe how you would like it to work - after
> refraining from using the public schema.
>
> David J.
>
And it's really easy to move a table to a different schema with "alter
table"
view thread (6+ messages) latest in thread
Message-ID: <906879c8-8e04-d436-ad7b-63ff057b1abb@gmail.com>
Permalink: ../906879c8-8e04-d436-ad7b-63ff057b1abb@gmail.com/
Also on: postgresql.org/message-id/906879c8-8e04-d436-ad7b-63ff057b1abb@gmail.com
reply
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-sql@postgresql.org
Cc: robjsargent@gmail.com, pgsql-sql@lists.postgresql.org
Subject: Re: create role/user management
In-Reply-To: <906879c8-8e04-d436-ad7b-63ff057b1abb@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox