Skip site navigation (1) Skip section navigation (2)

Re: authentication questions

From: Michael Hanna <zen(at)hwcn(dot)org>
To: "Mendola Gaetano" <mendola(at)bigfoot(dot)com>
Cc: "pgsql-novice" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: authentication questions
Date: 2003-06-27 12:58:15
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
OK, but what if you have thousands of users in your pg_shadow table? 
Can postgreSQL handle such a load?


On Friday, June 27, 2003, at 05:48  AM, Mendola Gaetano wrote:
> In that way you have less controll on who is using the DB,
> for example you can not use current_user in order to know
> who is doing the query and you can not use the privileges on
> tables, stored procedure, views.....
> and last but not least why you are aware about "do not fill the
> pg_shadow"?
> Regards
> Gaetano Mendola
> ---------------------------(end of 
> broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if 
> your
>       joining column's datatypes do not match

In response to


pgsql-novice by date

Next:From: Nabil SayeghDate: 2003-06-27 13:10:35
Subject: Re: Address Table
Previous:From: Rory Campbell-LangeDate: 2003-06-27 12:20:39
Subject: SELECT too complex?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group