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
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
