From: | Michael Fork <mfork(at)toledolink(dot)com> |
---|---|
To: | "Martin A(dot) Marques" <martin(at)math(dot)unl(dot)edu(dot)ar> |
Cc: | pgsql-hackers(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Re: grant privileges to a database |
Date: | 2001-01-31 18:53:04 |
Message-ID: | Pine.BSI.4.21.0101311352180.13116-100000@glass.toledolink.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
This is the closest thing to what you want:
GRANT ALL ON table TO user;
(see http://www.postgresql.org/users-lounge/docs/7.0/user/sql-grant.htm)
Michael Fork - CCNA - MCP - A+
Network Support - Toledo Internet Access - Toledo Ohio
On Wed, 31 Jan 2001, Martin A. Marques wrote:
> El Mar 30 Ene 2001 10:08, Martin A. Marques escribi:
> > Is there a way to grant a user with all privileges on a database? Something
> > like Informixs GRANT dba?
>
> OK, I see that no one responded (except one person how made a personal
> responce), so I'll add a bit to it.
> I seem to be aware that Postgres doesn't have a function to grant total
> access to a database, so is it posible to have this added to the todo list
> for further versions? Or is it posible to build a user-function that will let
> me do this:
>
> postgres(at)ultra3:~ > psql horde
>
> horde=# CREATE DATABASE test;
> CREATE DATABASE
> horde=# GRANT dba TO martin; -- here is the grant issue.
> GRANT
> horde=# \c test martin;
> You are now connected to database test as user martin.
> test=# CREATE TABLE (aid SERIAL, texto TEXT);
> CREATE TABLE
> test=#
>
> Saludos... ;-)
>
>
> --
> System Administration: It's a dirty job,
> but someone told I had to do it.
> -----------------------------------------------------------------
> Martn Marqus email: martin(at)math(dot)unl(dot)edu(dot)ar
> Santa Fe - Argentina http://math.unl.edu.ar/~martin/
> Administrador de sistemas en math.unl.edu.ar
> -----------------------------------------------------------------
>
From | Date | Subject | |
---|---|---|---|
Next Message | Mitch Vincent | 2001-01-31 18:54:48 | Re: php as stored procedures |
Previous Message | Gregory Wood | 2001-01-31 18:45:38 | Re: php as stored procedures |
From | Date | Subject | |
---|---|---|---|
Next Message | Martin A. Marques | 2001-01-31 19:41:59 | Re: Re: grant privileges to a database |
Previous Message | Barnes, Sandy (Sandra) | 2001-01-31 18:28:01 | [HACKERS] ERROR: "Database 'products', OID nnn, has disappeared from pg_database" |