Re: permissions problem? - Mailing list pgsql-novice

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)