HELP! BUG? pg_dump mucks up grant/revoke 
Author Message
 HELP! BUG? pg_dump mucks up grant/revoke

Hi:

I'm using pg 7.1.2.

I've got a database with views which have permissions granted to a certain
user.  Defined something like:

        create view whatever....

        revoke all on whatever from user
        grant select on whatever to user

(If I get the syntax wrong, it doesn't matter here.)

THEN, I do a pg_dump:

        pg_dump --attribute-inserts database > dump.sql

all well and good expect for one thing: the grant/revoke lines appear
BEFORE the create view definitions, so when I read the dump back into
postgres via:

        dropdb database
        createdb database
        cat dump.sql | psql database

I get "relation doesn't exist" errors and my "user" no longer has
permission to use those views.  This is a bug, isn't it?

Keith

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster



Sat, 10 Jan 2004 02:15:57 GMT
 HELP! BUG? pg_dump mucks up grant/revoke

(Hm. Not sure this went through the first time, so resending: sorry for
the duplicate.)

Hi:

I'm using pg 7.1.2.

I've got a database with views which have permissions granted to a
certain
user.  Defined something like:

        create view whatever....

        revoke all on whatever from user
        grant select on whatever to user

(If I get the syntax wrong, it doesn't matter here.)

THEN, I do a pg_dump:

        pg_dump --attribute-inserts database > dump.sql

all well and good expect for one thing: the grant/revoke lines appear
BEFORE the create view definitions, so when I read the dump back into
postgres via:

        dropdb database
        createdb database
        cat dump.sql | psql database

I get "relation doesn't exist" errors and my "user" no longer has
permission to use those views.  This is a bug, isn't it?

Keith

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command



Sat, 10 Jan 2004 02:52:42 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. bug in pg_dump with GRANT/REVOKE

2. HELP! BUG? pg_dump mucks up grant/revoke

3. Bug in grant/revoke when there are N-1 columns

4. Grant/revoke on Multiple objects!!Pls Help!!!Urgent!!

5. GRANT/REVOKE SQL HELP

6. Grant/revoke on Multiple objects!!Pls Help!!!Urgent!!

7. Grant/revoke on Multiple objects!!Pls Help!!!Urgent!!

8. Grant All and Revoke All in SqlServer 7.0

9. revoke select & grant select permission

10. Strange behavior with GRANT and REVOKE commands

11. Grant/Revoke Where?

12. GRANT / REVOKE on functions


 
Powered by phpBB® Forum Software