pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedAccess Permissions to Users
2+ messages / 2 participants
[nested] [flat]
* Access Permissions to Users
@ 2005-02-17 11:15 ganapatiram <ganapatiram@symphonydata.com>
0 siblings, 1 reply; 2+ messages in thread
From: ganapatiram @ 2005-02-17 11:15 UTC (permalink / raw)
To: pgsql-admin
Hi Experts,
I am using Postgresql 8.0 windows version. I am using this in the server as well as clients with the same access permissions to users as i am not aware how to set-up the access permissions for other users seperating super user.
If i want to give only view permissions to a set of users, how can i do that?
If i want to give only insert & view permissions to a set of users, how can i do that? and on...
Please let me know how can i set access permissions.
Thanks and Regards
Ram
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Access Permissions to Users
@ 2005-02-21 06:27 John DeSoi <desoi@pgedit.com>
parent: ganapatiram <ganapatiram@symphonydata.com>
0 siblings, 0 replies; 2+ messages in thread
From: John DeSoi @ 2005-02-21 06:27 UTC (permalink / raw)
To: ganapatiram <ganapatiram@symphonydata.com>; +Cc: pgsql-admin
On Feb 17, 2005, at 6:15 AM, ganapatiram wrote:
>
> I am using Postgresql 8.0 windows version. I am using this
> in the server as well as clients with the same access permissions to
> users as i am not aware how to set-up the access permissions for other
> users seperating super user.
>
> If i want to give only view permissions to a set of users,
> how can i do that?
>
> If i want to give only insert & view permissions to a set
> of users, how can i do that? and on...
>
>
> Please let me know how can i set access permissions.
Use CREATE GROUP to give permissions to a set of users.
http://www.postgresql.org/docs/8.0/interactive/sql-creategroup.html
The GRANT command is used to give permissions for specific operations
to users and/or groups.
http://www.postgresql.org/docs/8.0/interactive/sql-grant.html
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-02-21 06:27 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-02-17 11:15 Access Permissions to Users ganapatiram <ganapatiram@symphonydata.com>
2005-02-21 06:27 ` John DeSoi <desoi@pgedit.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