By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,710 Members | 1,960 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,710 IT Pros & Developers. It's quick & easy.

Grant alter privileges

P: n/a
I am working in a group that will be modifying tables on a regular basis.

We are using postgresql 7.3.4. Is there any way to allow the other users to modify tables I have created using either user or group permissions?
Thanks,

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Fri, Nov 14, 2003 at 16:30:25 -0600,
"Chris M. Gamble" <ch**********@cpbinc.com> wrote:
I am working in a group that will be modifying tables on a regular basis.

We are using postgresql 7.3.4. Is there any way to allow the other users to modify tables I have created using either user or group permissions?


Yes. You can use the GRANT command to give other users access to your objects.

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 12 '05 #2

P: n/a
Chris M. Gamble writes:
We are using postgresql 7.3.4. Is there any way to allow the other users
to modify tables I have created using either user or group permissions?


No. You would need to create a user for the owner and allow the other
group members to log in as that owner.

--
Peter Eisentraut pe*****@gmx.net
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.