Re: create role/user management
"David G. Johnston" <[email protected]> Mon, 6 May 2019 12:43:40 -0700
| Newsgroups | gmane.comp.db.postgresql.sql |
|---|---|
| Message-ID | <CAKFQuwYVVHSRYv3BS8FfC==qYJRBZi1yU_JJ-XFW96Oqdspy7A@mail.gmail.com> |
On Sat, May 4, 2019 at 9:38 AM Kirti Adesara <[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.