Schemas and access
От | felix-lists@crowfix.com |
---|---|
Тема | Schemas and access |
Дата | |
Msg-id | 16115.14223.827469.978456@crowfix.crowfix.com обсуждение исходный текст |
Ответы |
Re: Schemas and access
Re: Schemas and access |
Список | 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. Apparently I haven't quite got the hang of schema yet. Would someone enlighten me, please? -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow repairman & rocket surgeon / felix@crowfix.com GPG = E987 4493 C860 246C 3B1E 6477 7838 76E9 182E 8151 ITAR license #4933 I've found a solution to Fermat's Last Theorem but I see I've run out of room o
В списке pgsql-general по дате отправления: