Thank you for the information guys. I did manage to figure it out
eventually. And yes, I would prefer using groups in the real world. I
missed the preferences thing completely though.
Regards, Gerhard
begin:vcard
fn:Gerhard Botha
n:Botha;Gerhard
org:Winder Controls (Pty) LTD
adr:PO Box 383;;56
2009/3/5 Dave Page :
> On Thu, Mar 5, 2009 at 9:05 AM, Marcin Stępnicki wrote:
>
>> Go to File/Options/Preferences and turn on "Show users for
>> privileges". This should be default in my opinion.
>
> No it shouldn't. In most cases if you're configuring permissions for
> individual users then you'
On Thu, Mar 5, 2009 at 9:05 AM, Marcin Stępnicki wrote:
> Go to File/Options/Preferences and turn on "Show users for
> privileges". This should be default in my opinion.
No it shouldn't. In most cases if you're configuring permissions for
individual users then you're setting yourself up for futu
On Thu, Mar 5, 2009 at 7:59 AM, Gerhard Botha wrote:
> On my installation, the regular user is denied access to this table.
I think you've missed that you also need to grant USAGE privilege for
the schema. http://www.postgresql.org/docs/8.3/interactive/sql-grant.html
> I then log on as the super
I downloaded postgresql and pgadmin and am setting up an experimental
database in our company.
I have a basic grasp on relational databases but now need a bullet proof
tutorial on setting up users and privileges as well as dealing with
autoincremental primary keys.
We have a Linux server wit
