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
