Click here to get back home

DROP TABLE customers
 Home | NewsGroups | Search | About
Login Password
Register Now!
 comp.lang.perl.misc    Post an article   get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content
Subject Author Date
DROP TABLE customers Ignoramus26246 05-09-2008
Posted by Ignoramus26246 on May 9, 2008, 11:11 am
Please log in for more thread options
 I would like to know if Perl's DBI supports an attribute that would
make a database handle read only.

That is, I am looking for a way to make a handle read only so that all
subsequent queries that seek to modify the database, would not proceed
at all.

This would be for mysql.

Thanks
--
Due to extreme spam originating from Google Groups, and their inattention
to spammers, I and many others block all articles originating
from Google Groups. If you want your postings to be seen by
more readers you will need to find a different means of
posting on Usenet.
http://improve-usenet.org/

Posted by Captain Paralytic on May 9, 2008, 11:19 am
Please log in for more thread options
 wrote:
> I would like to know if Perl's DBI supports an attribute that would
> make a database handle read only.
>
> That is, I am looking for a way to make a handle read only so that all
> subsequent queries that seek to modify the database, would not proceed
> at all.
>
> This would be for mysql.
>
> Thanks
> --
> Due to extreme spam originating from Google Groups, and their inattention
> to spammers, I and many others block all articles originating
> from Google Groups. If you want your postings to be seen by
> more readers you will need to find a different means of
> posting on Usenet.
> http://improve-usenet.org/

I would reply, but according to your sig, you won't see it!

Posted by prawn on May 9, 2008, 11:20 am
Please log in for more thread options
On Fri, 09 May 2008 10:11:03 -0500, Ignoramus26246 wrote:

> I would like to know if Perl's DBI supports an attribute that would make
> a database handle read only.
>
> That is, I am looking for a way to make a handle read only so that all
> subsequent queries that seek to modify the database, would not proceed
> at all.
>
> This would be for mysql.
>
> Thanks

MySQL user security[1] will handle this.

[1] Given the normal implementation of MySQL in hosting environments,
this might be what you want to hear.[2]

[2] If so, try another way :-)
--
p BotM#1 LotR#9
http://www.last.fm/user/prawnuk

Posted by Captain Paralytic on May 9, 2008, 11:33 am
Please log in for more thread options
> On Fri, 09 May 2008 10:11:03 -0500, Ignoramus26246 wrote:
> > I would like to know if Perl's DBI supports an attribute that would make
> > a database handle read only.
>
> > That is, I am looking for a way to make a handle read only so that all
> > subsequent queries that seek to modify the database, would not proceed
> > at all.
>
> > This would be for mysql.
>
> > Thanks
>
> MySQL user security[1] will handle this.
>
> [1] Given the normal implementation of MySQL in hosting environments,
> this might be what you want to hear.[2]
>
> [2] If so, try another way :-)
> --
> p BotM#1 LotR#9http://www.last.fm/user/prawnuk
I think you meant:
[1] Given the normal implementation of MySQL in hosting environments,
this might NOT be what you want to hear.[2]

[2] If so, try another way :-)

Posted by prawn on May 9, 2008, 11:58 am
Please log in for more thread options
On Fri, 09 May 2008 08:33:15 -0700, Captain Paralytic wrote:

> I think you meant:
> [1] Given the normal implementation of MySQL in hosting environments,
> this might NOT be what you want to hear.[2]
>
> [2] If so, try another way :-)

Doh! Friday afternoon syndrome strikes.

--
p BotM#1 LotR#9
http://www.last.fm/user/prawnuk

Similar ThreadsPosted
Formatting a single line without effecting the entire table with the Text::Table module March 10, 2005, 11:18 am
Drag and drop March 3, 2005, 12:12 am
How to post back the data by selecting a value from drop down list November 20, 2006, 9:28 am
Select from drop down menu multipel times in the same form May 5, 2007, 11:34 am
Pb of key in a table September 20, 2005, 4:50 am
DBI and symbol table August 20, 2005, 3:12 pm
Help with a HTML table April 4, 2006, 8:47 am
table sorting May 3, 2006, 5:58 pm
How to get table from some html February 5, 2007, 12:48 am
how to new Table in a loop? March 21, 2007, 3:09 am

Our other projects:

Art Dolls, Fairies and Mermaids - Sunnyfaces.net

Roy's Linux, Programming and Search Engines messages

1-Script XML SitemapXML Sitemap