title: Get mysql.user unique id?
body: <p>In order to record the author credentials of a database item operation (such as creation or update operations), I am using the following architecture:</p>
  
  <pre><code>CREATE TABLE Items
  (id integer not null primary key auto_increment
  , Item_data varchar(50) not null
  , Item_lastmodified_author_name varchar(50) not null
  , Item_lastmodified_author_host varchar(100) not null
  , foreign key (Item_lastmodified_author_name) references mysql.user (User)
  , foreign key (Item_lastmodified_author_host) references mysql.user (Host)
  );
  </code></pre>
  
  <p>Is it not possible to make this easier with a unique mysql.user id reference ?</p>
  
  <p>One MySQL server is used for 3 teams. Each team has its own database. As the MySQL queries will be done from the client side.I don't want a user, member of one team, being able to change anything in another team database.</p>
  
  <p>Am I doing it the right way ?</p>