From: Braum Meakes <braum@telus.net>
To: pgsql-sql@postgresql.org
Subject: User Permissions
Date: Thu, 17 Jan 2002 14:27:39 -0800
Message-ID: <5.1.0.14.0.20020117141918.00a49e80@pop.telus.net> (raw)
Hello,
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?
I am unable to lock the table as a standard user at any time, not just when
running the function.
Thanks in advance,
Braum Meakes
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.20020117141918.00a49e80@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