Re: create role/user management

On 5/6/19 1:43 PM, David G. Johnston wrote:
> On Sat, May 4, 2019 at 9:38 AM Kirti Adesara <[email protected] 
> <mailto:[email protected]>> 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"