[HACKERS] pg_dump permissions

2005-10-19 Thread Christopher Kings-Lynne 
Suppose I have a database with a table in it.  I try to dump that 
database.  The user I dump as is not the owner of that table nor does it 
have the SELECT permission on that table.


Why can't I do a schema-only dump of that table?  I find that I need 
SELECT permission on the table, even though my user can happily query 
the catalogs.


PostgreSQL version: 7.4

Chris


---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

  http://www.postgresql.org/docs/faq

Re: [HACKERS] pg_dump permissions problem

2003-09-29 Thread Tom Lane 
Christopher Kings-Lynne [EMAIL PROTECTED] writes:
 My live 7.3.4 database dumps data like this:

 REVOKE ALL ON TABLE log_freeprofile FROM PUBLIC;
 GRANT ALL ON TABLE log_freeprofile TO brett;
 GRANT INSERT,SELECT,UPDATE ON TABLE log_freeprofile TO au-php;
 GRANT SELECT ON TABLE log_freeprofile TO GROUP readonly;
 REVOKE ALL ON TABLE log_freeprofile FROM auadmin;

 Now, loading this into 7.4beta3 gives this error:
 ERROR:  dependent privileges exist
 When executing the REVOKE ALL line.

Yeah, this is a known issue.  I think Peter was off looking into solutions.
It's clearly a must fix item.  Not sure if Bruce's open-items entry
Fix REVOKE ALL ON FUNCTION error when removing owner permissions
describes exactly the same problem or something else.

regards, tom lane

---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match

Re: [HACKERS] pg_dump permissions problem

2003-09-29 Thread Bruce Momjian 
Tom Lane wrote:
 Christopher Kings-Lynne [EMAIL PROTECTED] writes:
  My live 7.3.4 database dumps data like this:
 
  REVOKE ALL ON TABLE log_freeprofile FROM PUBLIC;
  GRANT ALL ON TABLE log_freeprofile TO brett;
  GRANT INSERT,SELECT,UPDATE ON TABLE log_freeprofile TO au-php;
  GRANT SELECT ON TABLE log_freeprofile TO GROUP readonly;
  REVOKE ALL ON TABLE log_freeprofile FROM auadmin;
 
  Now, loading this into 7.4beta3 gives this error:
  ERROR:  dependent privileges exist
  When executing the REVOKE ALL line.
 
 Yeah, this is a known issue.  I think Peter was off looking into solutions.
 It's clearly a must fix item.  Not sure if Bruce's open-items entry
   Fix REVOKE ALL ON FUNCTION error when removing owner permissions
 describes exactly the same problem or something else.

Yep, that is it.  It was reported as a bug by two people recently.

-- 
  Bruce Momjian|  http://candle.pha.pa.us
  [EMAIL PROTECTED]   |  (610) 359-1001
  +  If your life is a hard drive, |  13 Roberts Road
  +  Christ can be your backup.|  Newtown Square, Pennsylvania 19073

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faqs/FAQ.html