Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

permissions


  • From: Tom Allison <tom(at)tacocat(dot)net>
  • To: pgsql-general(at)postgresql(dot)org
  • Subject: permissions
  • Date: Sat, 21 Apr 2007 16:53:55 -0400
  • Message-id: <462A79E3(dot)9030306(at)tacocat(dot)net>

I am not sure how the permissions work anymore.

What I want to do is create a database and have a user create all the tables and rules.

I created the database from user postgres.
I then set the owner of the database to my userid

my userid created a number of tables and rules.

I then tried to migrate this database to a new user/owner.
But I keep getting

 permission denied for relation user_token


Which probably has to do with a relationship I have of referential integrity and a rule. The rule updates a second table, which I have update/insert rights to.

It's got the be the rule. I can do everything else, including what the rule is supposed to be.

how do a change the owner/permissions of the rule?



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group