From: stevenchang1213 <stevenchang1213@gmail.com>
To: Sunil Vasanta <sunilvasanta@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: Can I create multiple schema for one user
Date: Fri, 17 Feb 2017 23:52:53 +0800
Message-ID: <58a71c5c.4f90620a.9a2f1.e1fb@mx.google.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
hello,
Grant usage on schema xxx to user; Grant create on schema xxx to user; Grant "object level privilege" on xxx.object to user; orset 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: stevenchang1213@gmail.com, sunilvasanta@gmail.com
Subject: Re: Can I create multiple schema for one user
In-Reply-To: <58a71c5c.4f90620a.9a2f1.e1fb@mx.google.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox