Skip site navigation (1) Skip section navigation (2)

Re: Re: grant privileges to a database

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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
> -----------------------------------------------------------------
> 


In response to

Responses

pgsql-hackers by date

Next:From: Martin A. MarquesDate: 2001-01-31 19:41:59
Subject: Re: Re: grant privileges to a database
Previous:From: Barnes, Sandy (Sandra)Date: 2001-01-31 18:28:01
Subject: [HACKERS] ERROR: "Database 'products', OID nnn, has disappeared from pg_database"

pgsql-general by date

Next:From: Mitch VincentDate: 2001-01-31 18:54:48
Subject: Re: php as stored procedures
Previous:From: Gregory WoodDate: 2001-01-31 18:45:38
Subject: Re: php as stored procedures

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group