Fwd: not able to give usage access to public schema

Поиск
Список
Период
Сортировка
От sekhar chandra
Тема Fwd: not able to give usage access to public schema
Дата
Msg-id CAB7a7NaYcD9U+uWrMni7zstsQJSf2e9KKcyp5pzHSwuz4BbtMw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Fwd: not able to give usage access to public schema  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
I am not able to give usage permission to public schema. below are the steps.


Logged in as super user
created a new user as user1
grant usage on public to user1

command completed successfully , but verification statement showing he doesnt have usage permission.
SELECT rolnamehas_schema_privilege(rolname, 'public', 'usage') from pg_roles;  

this is strage. what could go wrong. 

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

Предыдущее
От: raf
Дата:
Сообщение: Re: Changing from security definer to security invoker withoutdropping ?
Следующее
От: Peter
Дата:
Сообщение: Re: Something else about Redo Logs disappearing