Postgres Pro
Downloads
Home   >   mailing lists

Thread: Access Permissions to Users

Access Permissions to Users

From
"ganapatiram"
Date:
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

Re: Access Permissions to Users

From
John DeSoi
Date:
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