On Mon, 2003-08-18 at 10:31, Andreas Pflug wrote:
> >
> AFAIR pgAdmin2 does have a grant utility for this. pgAdmin3 has this on
> the TODO for the next version.
>
> Regards,
> Andreas
>
I just used pgAdmin2's security wizard for this. Very nice. Just what I
needed.
Thanks,
Marcus
-
Marcus England wrote:
On Mon, 2003-08-18 at 09:29, Joe Conway wrote:
Marcus England wrote:
Again, I don't know what your definition of "most, if not all other
DBMS's" is, but a quick read through my MSSQL2000 manual indicates SQL
Server is no different from Postgres in this regard. Sa
Marcus England wrote:
IMHO, this is confusing and limiting for Administrators who wish to
grant privileges beyond CREATE, TEMPORARY, and TEMP across all tables in
a database. Something I believe most, if not all other DBMS's do. "ALL"
isn't very consistent.
Again, I don't know what your definition
On Mon, 2003-08-18 at 09:29, Joe Conway wrote:
> Marcus England wrote:
> Again, I don't know what your definition of "most, if not all other
> DBMS's" is, but a quick read through my MSSQL2000 manual indicates SQL
> Server is no different from Postgres in this regard. Same for Oracle 9i.
> I'd
Thank you Joe.
IMHO, this is confusing and limiting for Administrators who wish to
grant privileges beyond CREATE, TEMPORARY, and TEMP across all tables in
a database. Something I believe most, if not all other DBMS's do. "ALL"
isn't very consistent.
Reading the comments in the documentation, app
Marcus England wrote:
Grants do not work at the database level using the syntax mentioned in
the documentation. i.e.:
GRANT ALL ON DATABASE dbname TO GROUP groupname;
Or
GRANT ALL ON DATABASE dbname TO username;
Works here:
regression=# select version();
version
---
