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: | Whole Thread | Raw Message | 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
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 |