Grant alter privileges

Started by Chris M. Gambleover 22 years ago3 messagesgeneral
Jump to latest
#1Chris M. Gamble
chris.gamble@cpbinc.com

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,

#2Bruno Wolff III
bruno@wolff.to
In reply to: Chris M. Gamble (#1)
Re: Grant alter privileges

On Fri, Nov 14, 2003 at 16:30:25 -0600,
"Chris M. Gamble" <chris.gamble@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.

#3Peter Eisentraut
peter_e@gmx.net
In reply to: Chris M. Gamble (#1)
Re: Grant alter privileges

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 peter_e@gmx.net