pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Problems changing column attribute
2+ messages / 2 participants
[nested] [flat]

* Problems changing column attribute
@ 2006-11-07 10:36 Kuckuck Kuckuck <gentoopower@yahoo.de>
  2006-11-09 06:59 ` Re: Problems changing column attribute Jim C. Nasby <jim@nasby.net>
  0 siblings, 1 reply; 2+ messages in thread

From: Kuckuck Kuckuck @ 2006-11-07 10:36 UTC (permalink / raw)
  To: pgsql-admin

Hi folks, I have been breaking my head over this.
I logg in as testuser via pgadmin.
I create a table as user 'testuser' added some columns, one of them for example is name: 'testcolumn' type: varchar length: 50
Now I'd like to change testcolumn's length to 60, as user 'testuser' I'm not allowed to change it and pgadmin tells me  that I don't have the rights to change relation pg_attribute.

If I change the length of  'testcolumn' from an admin account it works. Now I granted all priviliges for this table to user 'testuser' via the admin account, but still I cannot change the length if I log in with 'testuser'.

Is there any chance to grant some user (in my case 'testuser') the right to change attributes, without making him superuser?

Thanks St.








	
		
___________________________________________________________ 
Der frühe Vogel fängt den Wurm. Hier gelangen Sie zum neuen Yahoo! Mail: http://mail.yahoo.de

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Problems changing column attribute
  2006-11-07 10:36 Problems changing column attribute Kuckuck Kuckuck <gentoopower@yahoo.de>
@ 2006-11-09 06:59 ` Jim C. Nasby <jim@nasby.net>
  0 siblings, 0 replies; 2+ messages in thread

From: Jim C. Nasby @ 2006-11-09 06:59 UTC (permalink / raw)
  To: Kuckuck Kuckuck <gentoopower@yahoo.de>; +Cc: pgsql-admin

On Tue, Nov 07, 2006 at 10:36:54AM +0000, Kuckuck Kuckuck wrote:
> Hi folks, I have been breaking my head over this.
> I logg in as testuser via pgadmin.
> I create a table as user 'testuser' added some columns, one of them for example is name: 'testcolumn' type: varchar length: 50
> Now I'd like to change testcolumn's length to 60, as user 'testuser' I'm not allowed to change it and pgadmin tells me  that I don't have the rights to change relation pg_attribute.
> 
> If I change the length of  'testcolumn' from an admin account it works. Now I granted all priviliges for this table to user 'testuser' via the admin account, but still I cannot change the length if I log in with 'testuser'.
> 
> Is there any chance to grant some user (in my case 'testuser') the right to change attributes, without making him superuser?

Can you reproduce this using psql? If you can, please provide us a
complete test case so others can look at it. If not, you'll need to post
on the pgAdmin list.
-- 
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2006-11-09 06:59 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-11-07 10:36 Problems changing column attribute Kuckuck Kuckuck <gentoopower@yahoo.de>
2006-11-09 06:59 ` Jim C. Nasby <jim@nasby.net>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox