List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:June 21 2000 2:07am
Subject:Re: How can read-only users create/drop temp tables?
View as plain text  
At 4:49 PM -0700 2000-06-20, Truoc Duong wrote:
>Hi Paul and Thimble,
>
>Thank you very much for your advice.  Joining tables
>from multiple databases is not a problem in normal
>SQL, but it is a lengthy and slow process in Perl DBI,
>which I am using.  That is why I wish to have the
>capability to create/drop temporary tables in my
>production database.  Since that feature is not
>available, I will just have to use the scratch
>database as you suggested.
>
>Thank you again.

Can you explain why using multiple tables is a lengthy and
slow process when using DBI?  That's actually the context
in which I usually use the temp database, and I have not
noticed any particular problem.

>
>--- Paul DuBois <paul@stripped> wrote:
>>  At 4:18 PM -0400 06/19/2000, Thimble Smith wrote:
>>  >On Mon, Jun 19, 2000 at 09:40:03AM -0700, Truoc
>>  Duong wrote:
>>  >>  I want to give my developers only a SELECT
>>  privillege
>>  >>  to all tables in my database.  But I also want
>>  to give
>>  >>  them the privillege to CREATE/DROP TEMPORARY
>>  (NOT
>>  >>  permanent) tables. Does anyone know how to do
>>  this in
>>  >>  MySQL?
>>  >
>>  >The MySQL privilege system doesn't handle this,
>>  although it is
>>  >a reasonable feature (I think).  The best
>>  replacement scheme I
>>  >can think of is to simply have a scratch database
>>  where they
>>  >can make tables.  You could set up a cron job to
>>  delete stale
>>  >tables out of the data directory.  (Yes, this is
>>  pretty ugly.)
>>  >
>>  >Tim
>>  >--
>>  >Tim Smith   < tim@stripped >  :MySQL Development
>>  Team:  Boone, NC  USA.
>>
>>
>>  I don't think it's that ugly.  But perhaps that's
>>  because this is
>>  the system I use.  It has the advantage that it
>>  keeps temporary tables
>>  out of the main database directory, too -- which is
>>  one problem that
>>  occurs if the developers forget to specify
>>  TEMPORARY, or if you're
>>  using a version of MySQL older than 3.23.
>>
>>  --
>  > Paul DuBois, paul@stripped


-- 
Paul DuBois, paul@stripped
Thread
How can read-only users create/drop temp tables?Truoc Duong19 Jun
  • Re: How can read-only users create/drop temp tables?Thimble Smith19 Jun
    • Re: How can read-only users create/drop temp tables?Thimble Smith20 Jun
    • Re: How can read-only users create/drop temp tables?Paul DuBois20 Jun
Re: How can read-only users create/drop temp tables?Truoc Duong21 Jun
  • Re: How can read-only users create/drop temp tables?Paul DuBois21 Jun
Re: How can read-only users create/drop temp tables?Truoc Duong22 Jun
  • Re: How can read-only users create/drop temp tables?Thimble Smith22 Jun
Re: How can read-only users create/drop temp tables?Truoc Duong22 Jun