Re: permissions

[Jim Nasby <decibel(at)decibel(dot)org>]

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 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?

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(at)nasby(dot)net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)