Re: Permissions to schema
| От | Scott Mead |
|---|---|
| Тема | Re: Permissions to schema |
| Дата | |
| Msg-id | d3ab2ec80910260504g22f2bb19s42adfa191684745b@mail.gmail.com обсуждение исходный текст |
| Ответ на | Permissions to schema (Eduardo Sá dos Reis <eduardoreis@pjf.mg.gov.br>) |
| Ответы |
Re: Permissions to schema
|
| Список | pgsql-admin |
2009/10/26 Eduardo Sá dos Reis <eduardoreis@pjf.mg.gov.br>
http://www.postgresql.org/docs/current/static/sql-revoke.html
kgb=# create schema s1;
CREATE SCHEMA
kgb=# create user mary;
CREATE ROLE
kgb=# revoke all on schema s1 from mary;
REVOKE
kgb=# create table s1.testing (id int);
CREATE TABLE
kgb=# \c kgb mary
kgb=> set search_path=s1;
SET
kgb=> \dt
No relations found.
kgb=> select * from s1.testing;
ERROR: permission denied for schema s1
kgb=>
--Scott
Hi,I have the structure on Postgre:database: dbGlobalschema1: sch_sist1 owner sch_sist1: johnschema2 sch_sist2 owner sch_sist2: maryI' m using pgAdmin III.Is there a way to avoid the mary to access the schema sch_sist1 ?I don't want that mary see/access the schema of john and I don't want that john see/access the schema of mary.Anybody has a solution.
http://www.postgresql.org/docs/current/static/sql-revoke.html
kgb=# create schema s1;
CREATE SCHEMA
kgb=# create user mary;
CREATE ROLE
kgb=# revoke all on schema s1 from mary;
REVOKE
kgb=# create table s1.testing (id int);
CREATE TABLE
kgb=# \c kgb mary
kgb=> set search_path=s1;
SET
kgb=> \dt
No relations found.
kgb=> select * from s1.testing;
ERROR: permission denied for schema s1
kgb=>
--Scott
В списке pgsql-admin по дате отправления: