Ah - my apologies, I realized you will need to add a function for exec
(which may also require plpgsql language added to your database).
On Tue, May 17, 2011 at 12:00 AM, Christopher Opena
wrote:
> Per 8.0 documentation, in order to ALTER a table (including rename), you
> have to be the owner of
2011/5/17 Adarsh Sharma :
> Dear all,
>
> Today I grant a user all privileges to all tables in a database by
>
> grant all privileges on svo_data_social to neha ; grant all
> privileges on svo_phrases to neha ;
> .. . .
> .
> ...
>
> Now i find it very uncomfort to grant
Per 8.0 documentation, in order to ALTER a table (including rename), you
have to be the owner of a table:
"You must own the table to use ALTER TABLE; except for ALTER TABLE OWNER,
which may only be executed by a superuser."
http://www.postgresql.org/docs/8.0/static/sql-altertable.html
If you want
Dear all,
Today I grant a user all privileges to all tables in a database by
grant all privileges on svo_data_social to neha ;
grant all privileges on svo_phrases to neha ;
.. . .
.
...
Now i find it very uncomfort to grant privileges one by one table.
Is there a
