List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:August 15 1999 4:25pm
Subject:Re: Granting authorities
View as plain text  
At 12:09 AM +1000 8/16/99, gleNN wrote:
>Hey,
>
>I'm trying to implement some user authentication with version 3.21.33 but
>I've no idea how to go about it. My (little) DBA experience is with DB2 -
>and there are a few issues that I need to resolve.
>
>Firstly, "GRANT is implemented in MySQL 3.22.11 or later." Believe it or
>not, this isnt really an issue for me =)
>
>Nonetheless, I think I've managed to set up the users as they should be.
>Next problem is to associate the authenticated user with a transaction.
>But without stored procedures I'm not sure how to do it. In all my tables
>I have a "USERID" column which I'd like to set to the current user
>automatically (for audit purposes). Anyone have any ideas on how to do
>this?

If I understand correctly what you want to do...

You cannot do it.  The user is set according to the user name that is
supplied to the server when you make your connection and does not change
thereafter.

-- 
Paul DuBois, paul@stripped
Thread
Granting authoritiesgleNN15 Aug
  • Re: Granting authoritiesPaul DuBois15 Aug
    • Re: Granting authoritiesgleNN16 Aug
      • Re: Granting authoritiesPaul DuBois16 Aug
        • Re: Granting authoritiesgleNN16 Aug
          • Re: Granting authoritiesBenjamin Pflugmann16 Aug