Postgres Pro
Downloads
Home   >   mailing lists

Fwd: not able to give usage access to public schema - Mailing list pgsql-general

From sekhar chandra
Subject Fwd: not able to give usage access to public schema
Date
Msg-id CAB7a7NaYcD9U+uWrMni7zstsQJSf2e9KKcyp5pzHSwuz4BbtMw@mail.gmail.com
Whole thread Raw
Responses Re: Fwd: not able to give usage access to public schema  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
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 rolname, has_schema_privilege(rolname, 'public', 'usage') from pg_roles;  

this is strage. what could go wrong. 

pgsql-general by date:

Previous
From: raf
Date:
Subject: Re: Changing from security definer to security invoker withoutdropping ?
Next
From: Peter
Date:
Subject: Re: Something else about Redo Logs disappearing