Postgres Pro
Downloads
Home   >   mailing lists

Thread: grant a db

grant a db

From
"Martin A. Marques"
Date:
Maybe I'm confused, but can I GRANT a user with ALL privileges on a database,
or does it have to do it on each table?

--
System Administration: It's a dirty job,
but someone told I had to do it.
-----------------------------------------------------------------
Martín Marqués            email:     martin@math.unl.edu.ar
Santa Fe - Argentina        http://math.unl.edu.ar/~martin/
Administrador de sistemas en math.unl.edu.ar
-----------------------------------------------------------------

RE: grant a db

From
"Nick Fankhauser"
Date:
I believe it has to be each table- Oracle has a nice "all tables" option
which might be worth the developer's consideration on the next round. I need
to do this regularly, so I'll probably see if I can write a tool to create a
SQL script. I'll let you know when I get it done.

-Nick

---------------------------------------------------------------------
Nick Fankhauser

Business:
nickf@ontko.com  Phone 1.765.935.4283  Fax 1.765.962.9788
Ray Ontko & Co.  Software Consulting Services  http://www.ontko.com/

Personal:
nickf@fankhausers.com   http://www.fankhausers.com




> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Martin A.
> Marques
> Sent: Tuesday, December 19, 2000 8:20 AM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] grant a db
>
>
> Maybe I'm confused, but can I GRANT a user with ALL privileges on
> a database,
> or does it have to do it on each table?
>
> --
> System Administration: It's a dirty job,
> but someone told I had to do it.
> -----------------------------------------------------------------
> Martín Marqués            email:     martin@math.unl.edu.ar
> Santa Fe - Argentina        http://math.unl.edu.ar/~martin/
> Administrador de sistemas en math.unl.edu.ar
> -----------------------------------------------------------------
>

Re: grant a db

From
"Martin A. Marques"
Date:
El Mar 19 Dic 2000 10:29, Nick Fankhauser escribió:
> I believe it has to be each table- Oracle has a nice "all tables" option
> which might be worth the developer's consideration on the next round. I
> need to do this regularly, so I'll probably see if I can write a tool to
> create a SQL script. I'll let you know when I get it done.

Well, thanks, but what I wanted was to make a determine user owner of the
database, so that he can create new tables, sequences, etc in that database.
But I guess that it isn't posible.

Thanks....


--
System Administration: It's a dirty job,
but someone told I had to do it.
-----------------------------------------------------------------
Martín Marqués            email:     martin@math.unl.edu.ar
Santa Fe - Argentina        http://math.unl.edu.ar/~martin/
Administrador de sistemas en math.unl.edu.ar
-----------------------------------------------------------------

Re: grant a db

From
"Dan Wilson"
Date:
Just recently added this functionality to phpPgAdmin.  You can now update
the ACL of all the objects (tables, sequences, views) of a database at the
same time.

This will be part of the next release (2.2.1) which should happen this week
sometime.  Look for the announcement.

-Dan

----- Original Message -----
From: "Nick Fankhauser" <nickf@ontko.com>
To: "Martin A. Marques" <martin@math.unl.edu.ar>
Cc: "pgsql-general" <pgsql-general@postgresql.org>
Sent: Tuesday, December 19, 2000 5:29 AM
Subject: RE: [GENERAL] grant a db


> I believe it has to be each table- Oracle has a nice "all tables" option
> which might be worth the developer's consideration on the next round. I
need
> to do this regularly, so I'll probably see if I can write a tool to create
a
> SQL script. I'll let you know when I get it done.
>
> -Nick
>
> ---------------------------------------------------------------------
> Nick Fankhauser
>
> Business:
> nickf@ontko.com  Phone 1.765.935.4283  Fax 1.765.962.9788
> Ray Ontko & Co.  Software Consulting Services  http://www.ontko.com/
>
> Personal:
> nickf@fankhausers.com   http://www.fankhausers.com
>
>
>
>
> > -----Original Message-----
> > From: pgsql-general-owner@postgresql.org
> > [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Martin A.
> > Marques
> > Sent: Tuesday, December 19, 2000 8:20 AM
> > To: pgsql-general@postgresql.org
> > Subject: [GENERAL] grant a db
> >
> >
> > Maybe I'm confused, but can I GRANT a user with ALL privileges on
> > a database,
> > or does it have to do it on each table?
> >
> > --
> > System Administration: It's a dirty job,
> > but someone told I had to do it.
> > -----------------------------------------------------------------
> > Martín Marqués email: martin@math.unl.edu.ar
> > Santa Fe - Argentina http://math.unl.edu.ar/~martin/
> > Administrador de sistemas en math.unl.edu.ar
> > -----------------------------------------------------------------
> >