pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Braum Meakes <braum@telus.net>
To: pgsql-sql@postgresql.org
Subject: Re: User Permissions
Date: Thu, 17 Jan 2002 15:20:12 -0800
Message-ID: <5.1.0.14.0.20020117151810.00a5ac70@pop.telus.net> (raw)
In-Reply-To: <Pine.LNX.4.30.0201171810290.725-100000@peter.localdomain>
References: <5.1.0.14.0.20020117141918.00a49e80@pop.telus.net>

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@gmx.net





view thread (8+ messages)  latest in thread

Message-ID: <5.1.0.14.0.20020117151810.00a5ac70@pop.telus.net>
Permalink:  ../5.1.0.14.0.20020117151810.00a5ac70@pop.telus.net/
Also on:    postgresql.org/message-id/5.1.0.14.0.20020117151810.00a5ac70@pop.telus.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: braum@telus.net
  Subject: Re: User Permissions
  In-Reply-To: <5.1.0.14.0.20020117151810.00a5ac70@pop.telus.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox