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(at)dorna(dot)es
Technical Engineer http://www.motograndprix.com
Dorna Sports S.L. +34 93 4702864