On Tue, 2011-08-23 at 06:43 -0700, igivanoff wrote:
> Hi,
>
> I have the following situation:
>
> postgres=# create database foo with encoding = 'UTF8';
> postgres=# \c foo
> foo=# CREATE SCHEMA sc;
> foo=# ALTER DATABASE foo SET search_path=sc, pg_catalog;
> foo=# CREATE ROLE usr LOGIN PASSWORD
Hi,
I have the following situation:
postgres=# create database foo with encoding = 'UTF8';
postgres=# \c foo
foo=# CREATE SCHEMA sc;
foo=# ALTER DATABASE foo SET search_path=sc, pg_catalog;
foo=# CREATE ROLE usr LOGIN PASSWORD 'usr' NOINHERIT CREATEDB VALID UNTIL
'infinity';
foo=# grant all privi
confidential nature and Sender does not
endorse distribution to any party other than intended recipient. Sender does
not necessarily endorse content contained within this transmission.
> From: [EMAIL PROTECTED]
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] grant privileges
>
On Saturday 08 November 2008 13:01, Andreas Kretschmer wrote:
> Garry Saddington <[EMAIL PROTECTED]> schrieb:
> > Is there a way to grant all priveleges on all tables and sequences in a
> > database at the same time?
>
Thanks I've just installed pgAdmin and that has done the trick.
Regards
Garry
-
Garry Saddington <[EMAIL PROTECTED]> schrieb:
> Is there a way to grant all priveleges on all tables and sequences in a
> database at the same time?
No, but there are several solutions for that:
14:00 < akretschmer> ??grantall
14:00 < pg_docbot_adz> For information about 'grantall' see:
14:00 <
On 08/11/2008 12:29, Garry Saddington wrote:
> Is there a way to grant all priveleges on all tables and sequences in a
> database at the same time?
Not easily, AFAIK - this question comes up from time to time, and you'll
find in the archives examples of scripts that pull object names from the
sys
Is there a way to grant all priveleges on all tables and sequences in a
database at the same time?
regards
Garry
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Thu, Apr 20, 2006 at 13:52:38 -0300,
Fernan Aguero <[EMAIL PROTECTED]> wrote:
> +[ Bruno Wolff III <[EMAIL PROTECTED]> (19.Apr.2006 14:39):
> |
> |
> | Granting access to a schema allows use of that schema. It does not grant
> | access to objects contained in the schema. You will need to
+[ Bruno Wolff III <[EMAIL PROTECTED]> (19.Apr.2006 14:39):
|
| On Wed, Apr 19, 2006 at 09:29:50 -0300,
| Fernan Aguero <[EMAIL PROTECTED]> wrote:
| >
| > The following works, but I'm not sure about the consequences
| > of granting USAGE to a schema, as the documentation is
| > not clear, IM
On Wed, Apr 19, 2006 at 09:29:50 -0300,
Fernan Aguero <[EMAIL PROTECTED]> wrote:
>
> The following works, but I'm not sure about the consequences
> of granting USAGE to a schema, as the documentation is
> not clear, IMO : "For schemas, allows access to objects
> contained in the specified schema
Hi,
I'm using a database that is splitted into a number of
schemas. In my local installation I'd like to have 3 users:
a dba (ALL privileges), a user with read-write
(INSERT/UPDATE/DELETE on all tables and views and SELECT on
all sequences) privileges and a user with read-only (SELECT
on all table
11 matches
Mail list logo
