pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedCan I create multiple schema for one user
3+ messages / 3 participants
[nested] [flat]
* Can I create multiple schema for one user
@ 2017-02-17 10:15 Sunil Vasanta <sunilvasanta@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Sunil Vasanta @ 2017-02-17 10:15 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Can I create multiple schema for one user
@ 2017-02-17 10:48 Albe Laurenz <laurenz.albe@wien.gv.at>
parent: Sunil Vasanta <sunilvasanta@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Albe Laurenz @ 2017-02-17 10:48 UTC (permalink / raw)
To: 'Sunil Vasanta *EXTERN*' <sunilvasanta@gmail.com>; pgsql-admin
Sunil Vasanta wrote:
> 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.
That shouldn't be a problem.
Just issue
SET serach_path = <whatever>
after you have determined the context.
Yours,
Laurenz Albe
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Can I create multiple schema for one user
@ 2017-02-17 15:52 stevenchang1213 <stevenchang1213@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: stevenchang1213 @ 2017-02-17 15:52 UTC (permalink / raw)
To: Sunil Vasanta <sunilvasanta@gmail.com>; pgsql-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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2017-02-17 15:52 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-02-17 10:15 Can I create multiple schema for one user Sunil Vasanta <sunilvasanta@gmail.com>
2017-02-17 10:48 ` Albe Laurenz <laurenz.albe@wien.gv.at>
2017-02-17 15:52 Re: Can I create multiple schema for one user stevenchang1213 <stevenchang1213@gmail.com>
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