On 5/6/19 1:43 PM, David G. Johnston 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"