pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedProviding user based previleges to Postgres DB
2+ messages / 2 participants
[nested] [flat]
* Providing user based previleges to Postgres DB
@ 2007-04-02 10:35 ramachandra.bhaskaram@wipro.com
2007-04-02 14:42 ` Re: Providing user based previleges to Postgres DB Carlos Moreno <moreno_pg@mochima.com>
0 siblings, 1 reply; 2+ messages in thread
From: ramachandra.bhaskaram@wipro.com @ 2007-04-02 10:35 UTC (permalink / raw)
To: pgsql-performance
Hi All,
Currently in one of the projects we want to restrict the unauthorized users to the Postgres DB. Here we are using Postgres version 8.2.0
Can anybody tell me how can I provide the user based previleges to the Postgres DB so that, we can restrict the unauthorized users as well as porivde the access control to the users based on the set previleges by the administrator.
Thanks and Regards,
Ramachandra B.S.
The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments.
WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.
www.wipro.com
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Providing user based previleges to Postgres DB
2007-04-02 10:35 Providing user based previleges to Postgres DB ramachandra.bhaskaram@wipro.com
@ 2007-04-02 14:42 ` Carlos Moreno <moreno_pg@mochima.com>
0 siblings, 0 replies; 2+ messages in thread
From: Carlos Moreno @ 2007-04-02 14:42 UTC (permalink / raw)
To: ramachandra.bhaskaram@wipro.com; +Cc: pgsql-performance
ramachandra.bhaskaram@wipro.com wrote:
>
> Hi All,
>
> Currently in one of the projects we want to restrict the
> unauthorized users to the Postgres DB. Here we are using Postgres
> version 8.2.0
>
> Can anybody tell me how can I provide the user based previleges
> to the Postgres DB so that, we can restrict the unauthorized users as
> well as porivde the access control to the users based on the set
> previleges by the administrator.
>
The pgsql-general list might be more appropriate for this type of
question... Still:
Are you talking restrictions based on database-users ? If so, look
up grant and revoke in the PG documentation (under SQL commands).
If you're talking about restricting system-users to even attempt to use
psql (which really, would not be much of a restriction), then perhaps
you would have to assign a group-owner to the file psql and grant
execute permission to the group only (well, and owner).
HTH,
Carlos
--
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2007-04-02 14:42 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-04-02 10:35 Providing user based previleges to Postgres DB ramachandra.bhaskaram@wipro.com
2007-04-02 14:42 ` Carlos Moreno <moreno_pg@mochima.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