Re: permissions problem?

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)