pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Access 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