Re: [GENERAL] Table permessions - solved

2012-01-18 Thread salah jubeh
I found this view information_schema.table_privileges Regards   From: salah jubeh To: pgsql Sent: Wednesday, January 18, 2012 2:48 PM Subject: [GENERAL] Table permessions Hello, I have create a table from another table such as CREATE TABLE

[GENERAL] Table permessions

2012-01-18 Thread salah jubeh
Hello, I have create a table from another table such as CREATE TABLE tmp_XXX AS SELECT * FROM XXX;  The  tmp_XXX  tables has no permissions assigned to it and I  want to assign it with the same owner and access privileges  of XXX  table. I had a look on pg catalog tables  http://www.postgre