Best procedure for restricted access

Поиск
Список
Период
Сортировка
От Rainer Leo
Тема Best procedure for restricted access
Дата
Msg-id 746856965.20110912151609@workfile.de
обсуждение исходный текст
Ответы Re: Best procedure for restricted access  (Craig Ringer <ringerc@ringerc.id.au>)
Список pgsql-admin
Hello,

I have been asked to configure a database role
to be used for ODBC access.

So far I have done this:

CREATE ROLE odbc_user LOGIN
  ENCRYPTED PASSWORD 'bar'
  NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE;

REVOKE ALL ON DATABASE foo FROM odbc_user;
REVOKE CREATE ON SCHEMA public FROM public;
GRANT SELECT ON v_sales TO odbc_user;

When I try:

foo-> SELECT * FROM customers;
access is denied as expected

foo->\d baz
I see table definitions.


How can I restrict the role "odbc_user" to just
"SELECT whatever FROM v_sales;" and nothing else?


Any help would be very appreciated.


Regards,

Rainer Leo

workfile Datenbankservice
Bocksberg 20c
D-22395 Hamburg                                

Fon: 040.60 44 90 41
Fax: 040.34 92 61 08
www.workfile.de


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

Предыдущее
От: Florian Helmberger
Дата:
Сообщение: Re: Encoding Problem
Следующее
От: Rainer Leo
Дата:
Сообщение: Best procedure for restricted access