permissions
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?
On Apr 21, 2007, at 9:53 PM, Tom Allison wrote:
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 useridmy userid created a number of tables and rules.
I then tried to migrate this database to a new user/owner.
But I keep gettingpermission 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?
We'll need more details than that. What exactly do you mean by 'tried
to migrate this database to a new user/owner'? What exact command are
you running and what's the exact error message are you getting?
--
Jim Nasby jim@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)