Re: Schemas and access
От | |
---|---|
Тема | Re: Schemas and access |
Дата | |
Msg-id | 65089.66.212.203.144.1056321801.squirrel@$HOSTNAME обсуждение исходный текст |
Ответ на | Schemas and access (felix-lists@crowfix.com) |
Список | pgsql-general |
> I am just beginning to investigate schemas, and have run into a > problem. Searching the mailing lists and documentation doesn't help. > > This is 7.3.3 on Linux, kernel 2.4.21, good ole Slackware, compiled > from source. > > Two users, JoeBob and MaryJo. JoeBob has schema xyzzy with table > plugh. JoeBob has run > > GRANT SELECT on xyzzy.plugh TO public; > > JoeBob and MaryJo can both show permissions: > > joebob=> \z zyzzy.* > Access privileges for database "joebob" > Schema | Table | Access privileges > --------+--------+-------------------- > xyzzy | plugh | {=r,joebob=arwdRxt} > > JoeBob can do anything with the table, that works. But MaryJo can't > even select: > > joebob=> select * from xyzzy.plugh; > ERROR: xyzzy: permission denied > > It sure looks like the schema itself is invisible to MaryJo, but > MaryJo can run \dt xyzzy.* perfectly fine. I think there is a "greant usage on schema" type statement that you probably need.
В списке pgsql-general по дате отправления: