Re: permissions problem? - Mailing list pgsql-novice

Oops!

Updating the script to DBI did help to solve the problem because it told
me that connection to the database had failed. The Pg version did say
'connect or die' and it obviously didn't die.  What more proof do you
need to update everything to DBI.

Thanks for you time anyway
Ann

ann hedley wrote:

> Sean
>
> The perl script is still using Pg and doesn't define a user/password.
> I've just started converting it to DBI but I don't think this will
> solve the problem.
>
> Sean Davis wrote:
>
>> Ann,
>>
>> The perl script uses DBI?  Did you use a username/password
>> combination there?
>>
>> Sean
>>
>> On Jan 20, 2005, at 5:21 AM, ann hedley wrote:
>>
>>> Hi
>>>
>>> I'm trying to insert values into a table with a perl script.  I know
>>> the script works with another database but it doesn't work with
>>> eandreibase, can anyone tell me why?
>>>
>>> I don't get any error messages and the insert commands work manually
>>> so I think it must be a permissions thing.
>>>
>>> The database was created by a perl script being run by ann and it is
>>> owned by ann.
>>>
>>> psql -l
>>>         List of databases
>>>    Name     |  Owner   | Encoding
>>> -------------+----------+-----------
>>> eandreibase | ann      | SQL_ASCII
>>>
>>> I (ann) created the table for the inserted data myself (domain
>>> table) an when I checked the access privileges this table had none.
>>> eandreibase=# \z
>>>  Access privileges for database "eandreibase"
>>> Schema |   Table    |     Access privileges
>>> --------+------------+---------------------------
>>> public | blast      | {=,ann=arwdRxt,webuser=r}
>>> public | blast_go   | {=,ann=arwdRxt,webuser=r}
>>> public | domain     |
>>> public | p4e_hsp    | {=,ann=arwdRxt,webuser=r}
>>> public | physprop   | {=,ann=arwdRxt,webuser=r}
>>> (14 rows)
>>>
>>> 'grant all on domain to ann'  has changed the access privileges but
>>> still the perl script, run by ann, doesn't insert any values.
>>>
>>> eandreibase=# \z domain
>>> Access privileges for database "eandreibase"
>>> Schema | Table  | Access privileges
>>> --------+--------+-------------------
>>> public | domain | {=,ann=arwdRxt}
>>>
>>>
>>> --
>>> Ann
>>>
>>> "In a world without walls and fences - who needs Windows and Gates ?"
>>>                                                           (unknown)
>>>
>>>
>>>
>>> ---------------------------(end of
>>> broadcast)---------------------------
>>> TIP 5: Have you checked our extensive FAQ?
>>>
>>>               http://www.postgresql.org/docs/faqs/FAQ.html
>>
>>
>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 4: Don't 'kill -9' the postmaster
>
>
>

--
Ann

"In a world without walls and fences - who needs Windows and Gates ?"
                                                           (unknown)