Thread: permissions problem?
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)
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
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)
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)