From: | ann hedley <ann(dot)hedley(at)ed(dot)ac(dot)uk> |
---|---|
To: | Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: permissions problem? |
Date: | 2005-01-20 11:26:22 |
Message-ID: | 41EF955E.6060707@ed.ac.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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)
From | Date | Subject | |
---|---|---|---|
Next Message | ann hedley | 2005-01-20 11:50:36 | Re: permissions problem? |
Previous Message | Sean Davis | 2005-01-20 11:13:17 | Re: permissions problem? |