Subject: Re: create role/user management
To: pgsql-sql@lists.postgresql.org
References: 
 <HK2PR0302MB2595F89036B915D9E784E6A0A1360@HK2PR0302MB2595.apcprd03.prod.outlook.com>
 <CAKFQuwYVVHSRYv3BS8FfC==qYJRBZi1yU_JJ-XFW96Oqdspy7A@mail.gmail.com>
From: Rob Sargent <robjsargent@gmail.com>
Message-ID: <906879c8-8e04-d436-ad7b-63ff057b1abb@gmail.com>
Date: Mon, 6 May 2019 13:49:15 -0600
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101
 Thunderbird/60.6.1
MIME-Version: 1.0
In-Reply-To: 
 <CAKFQuwYVVHSRYv3BS8FfC==qYJRBZi1yU_JJ-XFW96Oqdspy7A@mail.gmail.com>
Content-Type: multipart/alternative;
 boundary="------------6677FB9E4BCF53EF84538074"
Content-Language: en-US
Precedence: bulk

This is a multi-part message in MIME format.
--------------6677FB9E4BCF53EF84538074
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit


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"

--------------6677FB9E4BCF53EF84538074
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 7bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    <p><br>
    </p>
    <div class="moz-cite-prefix">On 5/6/19 1:43 PM, David G. Johnston
      wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:CAKFQuwYVVHSRYv3BS8FfC==qYJRBZi1yU_JJ-XFW96Oqdspy7A@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div dir="ltr">
        <div dir="ltr">
          <div class="gmail_default"
            style="font-family:arial,helvetica,sans-serif"><span
              style="font-family:Arial,Helvetica,sans-serif">On Sat, May
              4, 2019 at 9:38 AM Kirti Adesara &lt;<a
                href="mailto:kdadesara@hotmail.com"
                moz-do-not-send="true">kdadesara@hotmail.com</a>&gt;
              wrote:</span><br>
          </div>
        </div>
        <div class="gmail_quote">
          <blockquote class="gmail_quote" style="margin:0px 0px 0px
            0.8ex;border-left:1px solid
            rgb(204,204,204);padding-left:1ex">
            <div dir="ltr">
              <div
style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)"><span
                  style="font-size:12pt">I have a database with multiple
                  tables, functions and triggers in public schema.</span></div>
            </div>
          </blockquote>
          <div><br>
          </div>
          <div>
            <div class="gmail_default"
              style="font-family:arial,helvetica,sans-serif">You should
              stop using the public schema.</div>
          </div>
          <div class="gmail_default"
            style="font-family:arial,helvetica,sans-serif"><br>
          </div>
          <blockquote class="gmail_quote" style="margin:0px 0px 0px
            0.8ex;border-left:1px solid
            rgb(204,204,204);padding-left:1ex">
            <div dir="ltr">
              <div
style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">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.</div>
            </div>
          </blockquote>
          <div><br>
          </div>
          <div class="gmail_default"
            style="font-family:arial,helvetica,sans-serif">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.</div>
          <div class="gmail_default"
            style="font-family:arial,helvetica,sans-serif"><br>
          </div>
          <div class="gmail_default"
            style="font-family:arial,helvetica,sans-serif">David J.</div>
          <div class="gmail_default"
            style="font-family:arial,helvetica,sans-serif"><br>
          </div>
        </div>
      </div>
    </blockquote>
    And it's really easy to move a table to a different schema with
    "alter table"<br>
  </body>
</html>

--------------6677FB9E4BCF53EF84538074--