using ROLE system

From: Rafal Pietrak <rafal(at)zorro(dot)isa-geek(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: using ROLE system
Date: 2006-07-12 06:59:17
Message-ID: 1152687558.6764.72.camel@model.home.waw.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All,

I have a database where I give priviledges solely by user membership in
permitted roles (groups).

It works flowlessly, but when I tried to assign CREATEUSER priviledge to
an administrator ROLE (just one database administrator, not the
postmaster), I have to explicitly "SET ROLE ADMIN" before an attempt to
"CREATE USER ...". I don't have to do that to access tables/ views/
sequences, the group priviledges work OK just from being a member of
relevant group without the necesity to set current_role explicitly.

Is this a feature or a bug? Why?

My PostgresQL is v8.1.4.

And on a similar token: "SELECT current_user" works, while "SELECT
current_database" doesn't; yet "SELECT current_user()" doesn't work,
while "SELECT current_database()" does. Is this a feature or a bug?
--
-R

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rafal Pietrak 2006-07-12 07:32:41 Re: pgsql vs mysql
Previous Message Marc G. Fournier 2006-07-12 06:42:02 Re: 8.2 Beta ETA