Re: [ADMIN] How do I give user access to database?

1999-03-18 Thread Terry Mackintosh
Hi Dennis In psql get help like this: \h grant But to answwer your question, do: grant all on tablename to nobody; On Thu, 18 Mar 1999, someone wrote: > I have created a database as user "dennis", because dennis has > permission to create databases. > I want to access it through a PHP script

Re: [ADMIN] How do I give user access to database?

1999-03-18 Thread pete collins
grant all on databasename to nobody; will grant user nobody permission to insert, delete, select you can choose what kind of permission you want nobody to have you could ex: grant select on databasename to nobody; later someone wrote: > I have created a database as user "dennis", because d

[ADMIN] How do I give user access to database?

1999-03-18 Thread someone
I have created a database as user "dennis", because dennis has permission to create databases. I want to access it through a PHP script in a Web document, the web server is running as user "nobody", but user nobody does not have permission to use the database created by dennis. Nobody, cannot cre

Re: [ADMIN] delete data

1999-03-18 Thread Margarita Barvinok
DROP TABLE - Removes existing tables from a database DROP TABLE table [, ...] DELETE - Deletes rows from a table DELETE FROM table [ WHERE condition ] On Fri, 19 Mar 1999, hoelc wrote: > Hello, > can some one please tell me how to delete a table in a database and how > to delete one row a

[ADMIN] db out of memory

1999-03-18 Thread hoelc
Hello, I have a PostgreSQL database with Linux system. I use C language to write the database application interface programs, with libpq and ecpg. Some of the programs work fine, but some always give " db out of memory error ". Anyone have any idea what does this mean? Please advice. Thank you

[ADMIN] delete data

1999-03-18 Thread hoelc
Hello, can some one please tell me how to delete a table in a database and how to delete one row a data in a table, for a PostgreSQL database? Thank you very much. Regards.. lch