[ADMIN] initdb & pg_encoding

2000-05-29 Thread William Decker
Ok, I am ready to pull my hair out, what I have left!!   Here is what I got:   RedHat Linux 6.2 on an Athlon 700 processor with 128meg RAM and 30 gig of drive space.   What my problem is:   During the installation of PostgreSQL 6.5.3, I execute the initdb command using the postgres user acco

[ADMIN] grant select,update - bug or feature?

2000-05-29 Thread Eugene Karpachov
Excuse me for my bad English. Let us create test database as superuser: create table master ( i integer primary key, a text); -- I want to protect this table from updating by 'dbuser' create table slave ( j integer references master, b text); -- I want to enable updating

[ADMIN] few securiry questions

2000-05-29 Thread R D
hi there,I'm migrating from MySQL to PgSQL and I have few questions on PgSQL securiry: 1. How can I forbid to some users to create tables in some databases which they can acccess. 2. How can I GRANT/REJECT some privileges on all objects in a database TO/FROM some users, since i can't type "GRA