From: | Braum Meakes <braum(at)telus(dot)net> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: User Permissions |
Date: | 2002-01-17 23:20:12 |
Message-ID: | 5.1.0.14.0.20020117151810.00a5ac70@pop.telus.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
That's got it. Thanks!
At 06:12 PM 17/01/02 -0500, you wrote:
>Braum Meakes writes:
>
> > I have a function that I've written in plpgsql. In it I lock a table
> > before selecting a value and, depending on the value, either update the
> > record selected or insert a new one. It works perfectly when I run it as a
> > super-user or as the owner of the table. However, as a standard user I am
> > unable to lock the table. How do I either run the function at the owners
> > level, or change the permissions on the table to allow the user to lock it?
>
>Depending on what lock method you chose, you probably need to have UPDATE
>permission on the table. So, as the owner of the table, execute
>
>GRANT UPDATE ON tablename TO yourusername;
>
>For even higher lock-levels you need to be the table owner, but you
>probably don't want to use those anyway.
>
>--
>Peter Eisentraut peter_e(at)gmx(dot)net
From | Date | Subject | |
---|---|---|---|
Next Message | chester c young | 2002-01-17 23:42:08 | Re: User Permissions |
Previous Message | Peter Eisentraut | 2002-01-17 23:12:44 | Re: User Permissions |