Re: Best practice to grant all privileges on all bjects in database? - Mailing list pgsql-general

From Jorge Godoy
Subject Re: Best practice to grant all privileges on all bjects in database?
Date
Msg-id 200605252051.10257.jgodoy@gmail.com
Whole thread Raw
In response to Re: Best practice to grant all privileges on all bjects in database?  (Jim Nasby <jnasby@pervasive.com>)
List pgsql-general
Em Quinta 25 Maio 2006 19:33, Jim Nasby escreveu:
>
> Only helps if the OP is willing to run on HEAD; grant on sequence is
> not in 8.1 (at least not according to the docs).
>
> As for triggers, I don't really see how that would make any sense.

A trigger could start some modification in a table where the user has no
direct access to, e.g. a logging table.  By granting access to the trigger
and making the trigger able to access that table, then the operation could be
completed and data could ba safe from users.  I dunno, though, if the
permissions set to the function would allow that...

--
Jorge Godoy           <jgodoy@gmail.com>

pgsql-general by date:

Previous
From: Jorge Godoy
Date:
Subject: Re: What to expect when mixing inherited tables and different schemas while dealing with functions and views?
Next
From: Michael Fuhr
Date:
Subject: Re: move from 1 database to another