hiding metadata information from a user

Поиск
Список
Период
Сортировка
От Dinesh Bhandary
Тема hiding metadata information from a user
Дата
Msg-id 4D781A21.8030109@iii.com
обсуждение исходный текст
Ответы Re: hiding metadata information from a user  (Dinesh Bhandary <dbhandary@iii.com>)
Список pgsql-admin
Hi All -

Please let me know if this is possible to do in postgres.

I am creating a read only user, which has limited access to db objects,
primarily views. Even though this user can't query data from other db
objects it can view the system catalog using pg* views and tables,
thereby exposing our logical schema.
Is there a way in postgres to limit access to system catalogs. I just
want a pure read only user, which can do nothing but query specific
views we outlined.

Thanks!
Dinesh

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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: pg_clogs hanging around
Следующее
От: Selva manickaraja
Дата:
Сообщение: Proxy for psql