On Sun, Jan 29, 2006 at 02:01:51PM -0500, Tom Lane wrote:
> The 8.1 documentation uses the term "role", which seems unlikely to be
> confused with Unix groups:
...
> Good enough?
Yes :-)
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
--
Karsten Hilbert <[EMAIL PROTECTED]> writes:
> Aha ! Indeed, the 7.4 documentation wasn't clear enough on
> that (for me):
> "... The value samegroup specifies that the requested user
> must a member of the group with the same name as the
> requested database. ..."
> Might this be amended to say
On Sat, Jan 28, 2006 at 06:17:16PM -0500, Tom Lane wrote:
> > I am using a create_user() SP created by "postgres" with
> > "security definer" (gasp). This works just fine, however, it
> > transfers createuser rights to *anyone* allowed to connect
> > to the database the function is in.
>
> Not if
Karsten Hilbert <[EMAIL PROTECTED]> writes:
> I am using a create_user() SP created by "postgres" with
> "security definer" (gasp). This works just fine, however, it
> transfers createuser rights to *anyone* allowed to connect
> to the database the function is in.
Not if you restrict who's allowed
On Sat, Jan 28, 2006 at 11:04:09AM -0500, Tom Lane wrote:
> > I have a faint memory of it being possible to create users
> > "inside" *one* given database by way of a particular "create
> > user" syntax along the lines of:
> > create user [EMAIL PROTECTED] ...;
> There is the db_user_namespace kl
Karsten Hilbert <[EMAIL PROTECTED]> writes:
> I have a faint memory of it being possible to create users
> "inside" *one* given database by way of a particular "create
> user" syntax along the lines of:
> create user [EMAIL PROTECTED] ...;
There is the db_user_namespace kluge^H^H^H^H^Hparameter,
Hello,
I don't think you can create users *inside* a database, but for each
database,
you can create global users and make them members of a group having the same
name than your database.
Then, in pg_hba.conf, the folllowing line will give to your users the
permission to
connect to the datab
Hi all,
I have a faint memory of it being possible to create users
"inside" *one* given database by way of a particular "create
user" syntax along the lines of:
create user [EMAIL PROTECTED] ...;
or similar.
Was this ever possible in PostgreSQL or is my memory playing
tricks on me ? I went bac
Hello.
I had the following function in Postgres 8.0.4 for creation of users inside
existing groups. Now I need to adjust it for new Roles system. What do I
neeed to change?
Especially regarding: CMD := 'CREATE USER "' || l_username || '" WITH
ENCRYPTED PASSWORD ''' || l_password || ''' IN GROUP
How do I create users for postgress on an NT workstation?
> I am trying to run postgress on an NT workstation.
>
> Do I have to run it in a bash prompt?
>
> This is the error I get if I try to run postgres.exe at nt cmd prompt:
> D:\cygnus\cygwin-b20>postgres
> FATAL 1: SetPgUserName: no entr
;
Date: Wednesday, March 17, 1999 12:55 PM
Subject: [GENERAL] Creating Users
>Hi there,
>
>I'm fairly new with PGSQL so forgive me if I've missed something; I've
>tried to make as much sense of the docs as possible.
>
>I've done a 'createuser' a
11 matches
Mail list logo
