On 5/26/06, Jim Nasby <[EMAIL PROTECTED]> wrote:
Only helps if the OP is willing to run on HEAD; grant on sequence isnot in 8.1 (at least not according to the docs).you can grant on sequences using syntax for tables. works:([EMAIL PROTECTED]:5810) 08:59:21 [depesz]
# create sequence test;CREATE SEQ
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 wh
On May 24, 2006, at 10:50 AM, Bruno Wolff III wrote:
On Mon, May 22, 2006 at 12:59:06 +0300,
Joe Kramer <[EMAIL PROTECTED]> wrote:
On a related note, which objects need to be GRANTed specifically?
There is a saying that following objects can have permissions
GRANTed:
1. TABLE
2. DATABASE
3.
On Mon, May 22, 2006 at 12:59:06 +0300,
Joe Kramer <[EMAIL PROTECTED]> wrote:
> On a related note, which objects need to be GRANTed specifically?
> There is a saying that following objects can have permissions GRANTed:
> 1. TABLE
> 2. DATABASE
> 3. FUNCTION
> 4. LANGUAGE
> 5. SCHEMA
> 6. TABLESPA
On a related note, which objects need to be GRANTed specifically?
There is a saying that following objects can have permissions GRANTed:
1. TABLE
2. DATABASE
3. FUNCTION
4. LANGUAGE
5. SCHEMA
6. TABLESPACE
What about SEQUENCE, TRIGGER? PostgreSQL manual has no mention about this.
Thanks.
On 5/2
You can find some helpful grant scripts here:http://pgedit.com/tip/postgresql/access_control_functions
On 5/19/06, Joe Kramer <[EMAIL PROTECTED]> wrote:
Hello,I need to grant all privileges on all objects in database. Withoutusing SUPERUSER.It's strange that GRANT ALL PRIVILEGES ON DATABASE is usel
Hello,
I need to grant all privileges on all objects in database. Without
using SUPERUSER.
It's strange that GRANT ALL PRIVILEGES ON DATABASE is useless, it
don't grant privileges on tables.
I've found out this "best practice", (more like ugly workaround):
select 'grant all on '||schemaname||'
