Search Postgresql Archives

Re: Functions as a Security Layer

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Benjamin Stookey <jamstooks@xxxxxxxxx>
Subject: Re: Functions as a Security Layer
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Date: Sun, 08 Jan 2006 22:50:46 -0500
Cc: pgsql-general@xxxxxxxxxxxxxx
Comments: In-reply-to Benjamin Stookey <jamstooks@xxxxxxxxx> message dated "Sun, 08 Jan 2006 19:43:24 -0800"
In-reply-to: <20060109034324.86964.qmail@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
References: <20060109034324.86964.qmail@xxxxxxxxxxxxxxxxxxxxxxxxxxx>

Benjamin Stookey <jamstooks@xxxxxxxxx> writes:
> My question is, can I somehow give permissions to the
> function, but not to the user to protect the counter
> table from being modified in any ways I don't want?

Label the function SECURITY DEFINER.

			regards, tom lane

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Functions as a Security Layer
  - From: Benjamin Stookey

References:
- Functions as a Security Layer
  - From: Benjamin Stookey

Prev by Date: Functions as a Security Layer
Next by Date: Re: Oracle DB Worm Code Published
Previous by thread: Functions as a Security Layer
Next by thread: Re: Functions as a Security Layer
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux