<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-GB" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">Hi,<o:p></o:p></p>
<p class="MsoNormal"><br>
I am attempting to differentiate between active, and inactive Omero users from within the underlying database tables. I am able to see most of the information about specific users from the “password” and “experimenter” tables, but neither of these tables includes
an indication as to whether the user is active or inactive.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Does anyone know which table of the database this is stored in?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks<o:p></o:p></p>
<p class="MsoNormal">John<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style="line-height:12.0pt;background:white"><span style="font-size:12.0pt;font-family:"Times New Roman","serif";color:#4F81BD;mso-fareast-language:EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal" style="line-height:12.0pt;background:white"><b><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#4F81BD;mso-fareast-language:EN-GB">-------------------------------------------------------------------------------------------------------------------------------------------- <o:p></o:p></span></b></p>
<p class="MsoNormal" style="line-height:12.0pt;background:white"><b><span style="font-size:12.0pt;font-family:"Arial","sans-serif";color:#548DD4;mso-fareast-language:EN-GB">John Webber<br>
</span></b><span style="mso-fareast-language:EN-GB">Computing and Information Services<o:p></o:p></span></p>
<p class="MsoNormal" style="line-height:12.0pt;background:white"><span style="mso-fareast-language:EN-GB">NBI Partnership Ltd<o:p></o:p></span></p>
<p class="MsoNormal" style="line-height:12.0pt;background:white"><span style="mso-fareast-language:EN-GB">Norwich Research park<o:p></o:p></span></p>
<p class="MsoNormal" style="line-height:12.0pt;background:white"><span style="mso-fareast-language:EN-GB">Colney Lane<o:p></o:p></span></p>
<p class="MsoNormal" style="line-height:12.0pt;background:white"><span style="mso-fareast-language:EN-GB">Norwich</span><span style="mso-fareast-language:EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal" style="line-height:12.0pt;background:white"><span style="mso-fareast-language:EN-GB">NR4 7UH<o:p></o:p></span></p>
<p class="MsoNormal" style="line-height:12.0pt;background:white"><span style="mso-fareast-language:EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal" style="line-height:12.0pt;background:white"><span style="mso-fareast-language:EN-GB">E-Mail: john.webber@nbi.ac.uk<o:p></o:p></span></p>
<p class="MsoNormal" style="line-height:12.0pt;background:white"><span style="mso-fareast-language:EN-GB">Web: http://www.nbi.ac.uk<o:p></o:p></span></p>
<p class="MsoNormal" style="line-height:12.0pt;background:white"><span style="mso-fareast-language:EN-GB">Tel: +44(0)1603 450 818<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><i><span style="mso-fareast-language:EN-GB">The NBI Partnership Ltd provides non-scientific services to the Institute of Food Research, the John Innes Centre, The Genome Analysis Centre and The Sainsbury Laboratory<o:p></o:p></span></i></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>