On Tue, 17 Nov 1998 dkelson-list-pgsql-hackers@inconnect.com wrote:
> On Tue, 17 Nov 1998, Vince Vielhaber wrote:
>
> > On Mon, 16 Nov 1998 dkelson-list-pgsql-hackers@inconnect.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@michvhf.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
entitledto lecture me about bloat than the federal government" -- Tony Snow
==========================================================================