Re: [ADMIN] Can I create multiple schema for one user
От
stevenchang1213
Тема
Re: [ADMIN] Can I create multiple schema for one user
Дата
Msg-id
58a71c5c.4f90620a.9a2f1.e1fb@mx.google.com
Список
Дерево обсуждения
[ADMIN] Can I create multiple schema for one user Sunil Vasanta <sunilvasanta@gmail.com>
Re: [ADMIN] Can I create multiple schema for one user Albe Laurenz <laurenz.albe@wien.gv.at>
hello,
Grant usage on schema xxx to user;
Grant create on schema xxx to user;
Grant "object level privilege" on xxx.object to user;
or
set up default privilege on schema object to role, and grant the role to user
u need to study the relations anong role,user and schema. Or I don't think u can figure it out.
從我的 Samsung Galaxy 智慧型手機傳送。
-------- 原始訊息 --------
自： Sunil Vasanta <sunilvasanta@gmail.com>
日期： 2017/2/17 18:15 (GMT+08:00)
至： pgsql-admin@postgresql.org
主旨： [ADMIN] Can I create multiple schema for one user
Hi All,
I have a question,
I want application to access multiple scheme based on call context but only one user is created for application and application should access different schema using same user privilege and credentials.
is this possible in Postgres. Plz share u thoughts.
If possible then how to configure search path.
Thanks,
Sunny
В списке pgsql-admin по дате отправления
