Postgres Pro
Downloads
Home   >   mailing lists

Thread: Grant alter privileges

Grant alter privileges

From
"Chris M. Gamble"
Date:
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
useror group permissions? 


Thanks,

Re: Grant alter privileges

From
Bruno Wolff III
Date:
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
useror group permissions? 

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

Re: Grant alter privileges

From
Peter Eisentraut
Date:
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