<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 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 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:#0563C1;
text-decoration:underline;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@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="#0563C1" vlink="#954F72"><div class=WordSection1><p class=MsoNormal>Last thought:<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>When editing the config.dat by hand to put in users with server control capabilities I take it I’d use quotes there too?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>ii.sergni.privileges.user.”Adrian.Williamson”: SERVER_CONTROL,NET_ADMIN,MONITOR,TRUSTED<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Apologies for asking rather than just doing but I don’t have an Ingres 11 installation to hand that I can play with.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I’d need to ask for a temporary licence etc by which time the pubs would be open and I’d have higher priorities in hand.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Cheers<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Adrian<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span lang=EN-US style='mso-fareast-language:EN-GB'>From:</span></b><span lang=EN-US style='mso-fareast-language:EN-GB'> info-ingres-bounces@lists.planetingres.org <info-ingres-bounces@lists.planetingres.org> <b>On Behalf Of </b>Adrian Williamson<br><b>Sent:</b> 16 January 2020 15:24<br><b>To:</b> 'Martin Bowes' <martin.bowes@ndph.ox.ac.uk>; info-ingres@lists.planetingres.org<br><b>Subject:</b> Re: [Info-ingres] Dots in Ingres user names?<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Delimited Identifiers - <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><a href="https://docs.actian.com/ingres/11.0/index.html#page/SQLRef%2FSQL_Naming_and_Statement_Rules.htm%23ww108878">https://docs.actian.com/ingres/11.0/index.html#page/SQLRef%2FSQL_Naming_and_Statement_Rules.htm%23ww108878</a><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span lang=EN-US style='mso-fareast-language:EN-GB'>From:</span></b><span lang=EN-US style='mso-fareast-language:EN-GB'> Adrian Williamson <<a href="mailto:adrian.williamson@rationalcommerce.com">adrian.williamson@rationalcommerce.com</a>> <br><b>Sent:</b> 16 January 2020 15:19<br><b>To:</b> 'Martin Bowes' <<a href="mailto:martin.bowes@ndph.ox.ac.uk">martin.bowes@ndph.ox.ac.uk</a>>; 'info-ingres@lists.planetingres.org' <<a href="mailto:info-ingres@lists.planetingres.org">info-ingres@lists.planetingres.org</a>><br><b>Subject:</b> RE: [Info-ingres] Dots in Ingres user names?<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Oh nice – thank you Marty.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span lang=EN-US style='mso-fareast-language:EN-GB'>From:</span></b><span lang=EN-US style='mso-fareast-language:EN-GB'> Martin Bowes <<a href="mailto:martin.bowes@ndph.ox.ac.uk">martin.bowes@ndph.ox.ac.uk</a>> <br><b>Sent:</b> 16 January 2020 14:53<br><b>To:</b> Adrian Williamson <<a href="mailto:adrian.williamson@rationalcommerce.com">adrian.williamson@rationalcommerce.com</a>>; <a href="mailto:info-ingres@lists.planetingres.org">info-ingres@lists.planetingres.org</a><br><b>Subject:</b> RE: [Info-ingres] Dots in Ingres user names?<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span style='color:#1F497D'>In accessdb you create the username as a double quoted string.<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Martin Bowes<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma",sans-serif;mso-fareast-language:JA'>From:</span></b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma",sans-serif;mso-fareast-language:JA'> Adrian Williamson [<a href="mailto:adrian.williamson@rationalcommerce.com">mailto:adrian.williamson@rationalcommerce.com</a>] <br><b>Sent:</b> 16 January 2020 14:08<br><b>To:</b> <a href="mailto:info-ingres@lists.planetingres.org">info-ingres@lists.planetingres.org</a><br><b>Subject:</b> [Info-ingres] Dots in Ingres user names?<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Hi,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I’ve a number of customers who have Active Directory naming standard that include forename and surname e.g. Adrian.Williamson<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Ingres (accessdb) doesn’t like this.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Is that a difficult thing for the product to do?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>'adrian.williamson ' is an invalid username or a reserved word.<o:p></o:p></p><p class=MsoNormal>Legal characters are alphanumerics, '@', '#', '$', and '_'. The first<o:p></o:p></p><p class=MsoNormal>character must be alphabetic. Maximum length is 256 characters.<o:p></o:p></p><p class=MsoNormal>(E_IC002D)<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Cheers<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Adrian<o:p></o:p></p></div></body></html>