CODEWITHSUNDEEP
database-schemaprivilegessql-grantpostgresql-9.2
Tim
Tim

Reputation: 8921

postgreSQL: grant select on all tables in schema FOO to FOOROLE

EDIT: Found it. I thought USAGE was an explanation, not a key word. :-)

What else must occur in addition to

 GRANT SELECT ON ALL TABLES    IN SCHEMA FOO to FOOROLE

in order for FOOROLE to be able to select from, say, FOO.CUSTOMER? Is there some general schema-access privilege that must also be granted?

FOOROLE was created with LOGIN and can log into the database, but is being denied:

   ERROR:  permission denied for schema foo
   LINE 1: select * from foo.customer


   ********** Error **********

   ERROR: permission denied for schema foo
   SQL state: 42501
   Character: 15  (caret points to the first character of "foo")

Upvotes: 3

Views: 4829

Answers (1)

Tim
Tim

Reputation: 8921

USAGE is the generic permission I was seeking.

Upvotes: 2

Related Questions