Re: hanging psql session while granting...

On Thu, 2002-02-14 at 13:45, Kumar, Lakshmi (Cognizant) wrote:

> How can i change the Grants over tables to other users ... is there any
> round about way ?
> Or where could be the problem.

First, I imagine you have permissions to make this.
When I want to change the permissions over a table, or tables, I use
this:

psql name_of_you_database < kk.sql | sed -e '1,3d' | awk '{print "GRANT
"$priv" ON "$1" TO "$user";"}'>gdornaout

psql motograndprix < gdornaout

You need to set $priv (privileges), $user (affected user) firts.

--
Manuel Trujillo         manueltrujillo@dorna.es
Technical Engineer      http://www.motograndprix.com
Dorna Sports S.L.       +34 93 4702864