Skip site navigation (1) Skip section navigation (2)

RE: Access Control in PostGreSQL

From: <jeff(dot)fitzmyers(at)managestar(dot)com>
To: <vijayendra(dot)agrawal(at)wipro(dot)com>, <pgsql-admin(at)postgresql(dot)org>
Subject: RE: Access Control in PostGreSQL
Date: 2001-04-13 17:16:13
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Have you tried this:
As data base superuser, GRANT INSERT ON <table> TO <user>;


-----Original Message-----
From: vijayendra mohan agrawal [mailto:vijayendra(dot)agrawal(at)wipro(dot)com]
Sent: Thursday, April 12, 2001 3:01 AM
To: PostGre SQL Mailing List
Subject: Access Control in PostGreSQL


From my UNIX login, which is a valid user for the database too, I
connect to
database. I don't have permission to add, delete, view system tables

Now, if I use the command "CONNECT" as user "pgadmin", which is
administrator of the database, the connect succeeds, and now, I am able
do anything in the system files too.

I guess this is not intentional. I might be missing something. Please

Thanks and Regards

pgsql-admin by date

Next:From: Richard T. RobinoDate: 2001-04-13 18:30:04
Subject: Re: [OT] PgSQL Feature List
Previous:From: Tom LaneDate: 2001-04-13 16:02:33
Subject: Re: Re: [GENERAL] ERROR: cannot read block 1452 from data (HELP!!!! I'MDESPERATE!)

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group