alter table / permissions

From: "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: alter table / permissions
Date: 2003-03-07 21:13:30
Message-ID: 73309C2FDD95D11192E60008C7B1D5BB04C7475E@snt452.corp.bcbsm.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Howdy:

Running PostgreSQL 7.2.1 on RedHat Linux 7.2.

I want to change / alter someone else's table and add a column.
I think that I have to give myself permission for such things,
but when I try to make the modification, I get 'permission
denied'.

[snip example]

test_db=> \c bcn joe
You are now connected to database bcn as user joe.
test_db=> alter table tm_pg_hmp_num add column product text;
ERROR: ALTER TABLE: permission denied
test_db=> \z tm_pg_hmp_num
Access privileges for database "test_db"
Table | Access privileges
-------------------+------------------------------
tm_pg_hmp_num | {=r,tom=arwdRxt,joe=arwdRxt}
tm_pg_hmp_num_bak |
(2 rows)

[/snip example]

Since Tom is the creator of the table, is it only HE that
get's to make the modification? I thought that we both
have the same rights and privilages. Not true?

Thanks!

-X

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Eric B.Ridge 2003-03-07 21:36:57 Re: division by zero
Previous Message Charlie Woloszynski 2003-03-07 21:12:10 PITR status