Re: [HACKERS] New to PostgreSQL, is this a DoS?

On Tue, 17 Nov 1998 dkelson-list-pgsql-hackers(at)inconnect(dot)com wrote:

> On Tue, 17 Nov 1998, Vince Vielhaber wrote:
>
> > On Mon, 16 Nov 1998 dkelson-list-pgsql-hackers(at)inconnect(dot)com wrote:
> >
> > > I compiled and install 6.4 according to the INSTALL doc.
> > >
> > > I created a database with "createdb test",
> > >
> > > running as user "postgres", I connected "psql template1" and ran:
> > >
> > > CREATE USER billybob WITH PASSWORD hehe CREATEDB CREATEUSER;
> >
> > Still being half asleep and just guessing (withoug looking it up), does
> > the CREATEDB CREATEUSER also imply SELECT privileges? IOW, you may
> > wanna try GRANT.
>
> >From what I've read, you can't GRANT on a database, it has be a on an
> object within a database.
>
> It seems it is the chicken and the egg problem.

GRANT ALL TO billybob

That's a GRANT for command permissions which is different from the GRANT
for object permissions that you're thinking of. Sybase supports the
above command I gave, I don't know if PostgreSQL does.

Vince.
--
==========================================================================
Vince Vielhaber -- KA8CSH email: vev(at)michvhf(dot)com flame-mail: /dev/null
# include <std/disclaimers.h> TEAM-OS2
Online Searchable Campground Listings http://www.camping-usa.com
"There is no outfit less entitled to lecture me about bloat
than the federal government" -- Tony Snow
==========================================================================