modifying a linux database.

alejan74 · 02-11-2005, 09:21 AM

I have a database in a linux machine. I have a dbase connection to it via a windows 2000 workstation using access 2002. We have a connection to the database, however we cant make any changes to it. We can view the database but we cannot delete any entries and see those changes reflected on the database at the linux workstation. we can make the changes on the database from the linux box, but we cannot do it from the windows 2000 workstation.

Any feedback will be great.

vharishankar · 02-11-2005, 10:00 AM

What database are you running on Linux? MySQL, Postgresql or what?

alejan74 · 02-11-2005, 12:14 PM

using postgresql

jmercier · 02-11-2005, 12:59 PM

Does the user your connecting with have rights to do updates/deletes, inside pgsql?

Justin

alejan74 · 02-15-2005, 03:09 PM

How do i go about checking the permissions on the postgresql. Do i check it on the win 2k workstation or on the linux workstation. In terms of admin rights on the win2k workstation i gave him administrative rights. Do I need to add the workstation to a group of some kind on the linux workstation

any feedback will be great.

alex

jmercier · 02-15-2005, 03:19 PM

Permissions would be changed inside the database itself(from the linux workstation).

Should probably read this.

http://www.postgresql.org/docs/7.4/i...rivileges.html

Justin