On 5/6/19 1:43 PM, David G. Johnston wrote:
> On Sat, May 4, 2019 at 9:38 AM Kirti Adesara <kdadesara(at)hotmail(dot)com
> <mailto:kdadesara(at)hotmail(dot)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"