Re: ALTER USER versus GRANT/REVOKE

On Fri, 30 Aug 2002 08:29:11 -0700
Ron Snyder  wrote:
>
> journal=> \h grant
> Command:     GRANT
> Description: Grants access privilege to a user, a group or all users
> Syntax:
> GRANT privilege [, ...] ON object [, ...]
>     TO { PUBLIC | GROUP group | username }
> 
> Am I misunderstanding your question, or is this what you're looking for?
> 
I was not refering to access privileges for specific objects, but to
general user privileges like

	- CREATEDB
	- CREATEUSER
	- CREATETABLE    (not yet supported by PG)
	- CREATEFUNCTION (not yet supported by PG)
	- ...            (not yet supported by PG)

These are granted with ALTER USER in PG 7.2.

Although PG has very limited support for these at the moment, I see
a problem with the current implementation if it is extended to more
user privileges.

Christoph