Re: create role/user management

Поиск
Список
Период
Сортировка
От Steve Midgley
Тема Re: create role/user management
Дата
Msg-id CAJexoSKNMuRHD2ssKMFaYsa8inLKnDpZpD9zcYTBvZD5QX7KJA@mail.gmail.com
обсуждение исходный текст
Ответ на create role/user management  (Kirti Adesara <kdadesara@hotmail.com>)
Список pgsql-sql
On Sat, May 4, 2019 at 9:38 AM Kirti Adesara <kdadesara@hotmail.com> wrote:
Hi

I have a database with multiple tables, functions and triggers in 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.

Can you clarify your intention/goal? You write that you want a user role to "select on specific tables" but "cannot access... specific tables." Do you mean you want by default a user role that can't access any functions, triggers or tables, and then can be "whitelisted" into access to a limited, defined list of tables?

Steve

В списке pgsql-sql по дате отправления:

Предыдущее
От: "Sonnenberg-Carstens, Stefan"
Дата:
Сообщение: AW: plpython transforms vs. arrays
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: create role/user management