A step in the right direction for this to have the system catalog have
pg_user_* views. So dor databases we have:
create view pg_user_database as
select * from pg_database where pg_get_userbyid(datdba) = CURRENT_USER
Of course, this doesn't account for superusers, but I'm sure there is a way
th
You can do this in phpPgAdmin... it's a hack because it just pulls in all
the objects/relations and runs a single grant statement on them, but it
works. It puts together a query like the following:
GRANT ALL ON table1, table2, table3, view1, view2, sequence1, sequence2 TO
user
Which I suppose y
: El Mié 31 Ene 2001 18:32, Dan Wilson escribió:
: > You can do this in phpPgAdmin... it's a hack because it just pulls in
all
: > the objects/relations and runs a single grant statement on them, but it
: > works. It puts together a query like the following:
: >
: > GRANT A
> > - Original Message -
> > From: "Dan Wilson" <[EMAIL PROTECTED]>
> > To: "pgsql general" <[EMAIL PROTECTED]>
> > Sent: Sunday, November 19, 2000 9:33 AM
> > Subject: DB and Table Permissions
> >
> > > Is there
I sent this to the general list and got no response so I figure I can take
it to the people who actually make the decisions.
Is this a security bug or is it by design?
- Original Message -
From: "Dan Wilson" <[EMAIL PROTECTED]>
To: "pgsql general" <[E
