[ADMIN] Restricting the access to a database

2006-02-28 Thread KyLiE
Hi all, im new in this and my question can sound stupid, here is the thing, i have a server wich have 3 databases, each one with different users(user1, user2 and user3) user1 have : db1, db2 and db3 user2 have : example1 and user3 have : pgadmin Im trying this : I want that user1 have access

[ADMIN] %psql help

2006-07-05 Thread KyLiE
Hi all, I'm quiet new in this stuff, I have N psql users and N databases, each user has a database and can connect to it using his psql account, however I don't want to allow that some user access to another database that does not belong to him. I've modify my pg_hba.conf file, and allow the a

[ADMIN] %Alter Help

2006-07-10 Thread KyLiE
Hi all, I have a new question, know i'm trying to alter one of my tables,but the thing is, that I need to change the range of one of my columns, I've allready try this: ALTER TABLE lugar alter column sitio varchar2(500); but it gives me a syntax error. and i don't know why. Any help I'll appr