Re: [ADMIN] Irrevocable privileges

2005-05-11 Thread Tom Lane
"Dave Held" <[EMAIL PROTECTED]> writes: > I don't know what a permission of "*" means, so that's what I call "limbo". It means you still have grant options. This is fixed in 8.0. regards, tom lane ---(end of broadcast)--- T

Re: [ADMIN] Irrevocable privileges

2005-05-11 Thread Dave Held
> -Original Message- > From: Tom Lane [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 10, 2005 6:11 PM > To: Dave Held > Cc: pgsql-admin@postgresql.org > Subject: Re: [ADMIN] Irrevocable privileges > > > "Dave Held" <[EMAIL PROTECTED]> writes:

Re: [ADMIN] Irrevocable privileges

2005-05-10 Thread Tom Lane
"Dave Held" <[EMAIL PROTECTED]> writes: > I think it's silly that any privileges that an owner grants to himself = > are essentially irrevocable. Say again? An owner can certainly revoke his own ordinary privileges. > Consider: > User joe creates table foo > User joe grants permission rw to him

[ADMIN] Irrevocable privileges

2005-05-10 Thread Dave Held
Title: Irrevocable privileges I think it's silly that any privileges that an owner grants to himself are essentially irrevocable.  It's silly because it makes changing the object owner pointless.  Consider: User joe creates table foo User joe grants permission rw to himself on foo User