List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:July 27 1999 7:03pm
Subject:Re: Restrict Access
View as plain text  
At 11:51 AM -0700 7/27/99, Thimble Smith wrote:
>At 15:29, 19990727, sinisa@stripped wrote:
>>toxalot@stripped writes:
>> > Access to the database requires a piad subscription and we don't want
>> > companies buying one subscription and then letting all employess use the
>> > same user name.
>>
>>select get_lock("user_name",10000);
>>.........
>>
>>select release_lock("user_name");
>
>Since the lock names are global (i.e., not qualified by the database
>or user or anything else), I would suggest using a longer name for
>your locks, which includes a unique identifier for YOU, one for the
>COMPANY you're dealing with, and finally the specific USER you are
>locking out.  For example, you might use
>
>    select get_lock("YOUR-DB-NAME;The Company;user_name", 10000);
>
>You don't know who else is using locks on the database system that
>you're running.
>
>Huh, that makes me wonder - what privileges are required to select
>get_lock()?  Would it be possible, on a shared system (like at an
>ISP that provides MySQL support), for someone to deny service to a
>totally unrelated account by acquiring locks that they depend on,
>and not releasing them?


I have a fairly basic question about GET_LOCK():  what is it that's
being locked?

-- 
Paul DuBois, paul@stripped
Thread
Restrict Accesstoxalot27 Jul
  • Restrict Accesssinisa27 Jul
    • Re: Restrict AccessThimble Smith27 Jul
      • Re: Restrict AccessPaul DuBois27 Jul
        • Re: Restrict AccessMartin Ramsch27 Jul
          • Re: Restrict AccessPaul DuBois28 Jul
            • Re: Restrict AccessThimble Smith28 Jul
        • Re: Restrict Accesssinisa28 Jul
    • Re: Restrict Accesstoxalot28 Jul
      • On GET_LOCK ()sinisa28 Jul
        • Re: On GET_LOCK ()Benjamin Pflugmann28 Jul
          • Re: On GET_LOCK ()sinisa28 Jul
            • Re: On GET_LOCK ()Paul DuBois28 Jul
          • Re: On GET_LOCK ()Jim Faucette28 Jul
            • Re: On GET_LOCK ()Paul DuBois28 Jul
              • Re: On GET_LOCK ()Thimble Smith28 Jul
          • Re: On GET_LOCK ()Gerald Clark28 Jul
        • Re: On GET_LOCK ()Paul DuBois28 Jul
          • Re: On GET_LOCK ()sinisa28 Jul
            • Re: On GET_LOCK ()Paul DuBois28 Jul
  • Re: On GET_LOCK ()Scott Hess28 Jul
    • getting rid of duplicatesJoel Bremson28 Jul
    • Re: getting rid of duplicatesChristian Mack28 Jul
    • Re: On GET_LOCK ()sinisa29 Jul
      • Re: On GET_LOCK ()Paul DuBois29 Jul
    • Re: On GET_LOCK ()Scott Hess29 Jul
Re: On GET_LOCK ()toxalot28 Jul
  • Re: On GET_LOCK ()sinisa28 Jul
    • Re: On GET_LOCK ()Benjamin Pflugmann29 Jul
  • Re: On GET_LOCK ()Sasha Pachev29 Jul
    • Re: On GET_LOCK ()Benjamin Pflugmann31 Jul
Re: On GET_LOCK ()Thimble Smith29 Jul
  • Re: On GET_LOCK ()Fraser MacKenzie29 Jul
    • Re: On GET_LOCK ()Thimble Smith29 Jul
      • Re: On GET_LOCK ()Fraser MacKenzie29 Jul
Re: On GET_LOCK()R. Mentink31 Jul