[Info-ingres] Dots in Ingres user names?

[Adrian Williamson]

Delimited Identifiers - 

 

https://docs.actian.com/ingres/11.0/index.html#page/SQLRef%2FSQL_Naming_and_
Statement_Rules.htm%23ww108878

 

From: Adrian Williamson <adrian.williamson at rationalcommerce.com> 
Sent: 16 January 2020 15:19
To: 'Martin Bowes' <martin.bowes at ndph.ox.ac.uk>;
'info-ingres at lists.planetingres.org' <info-ingres at lists.planetingres.org>
Subject: RE: [Info-ingres] Dots in Ingres user names?

 

Oh nice - thank you Marty.

 

From: Martin Bowes <martin.bowes at ndph.ox.ac.uk
<mailto:martin.bowes at ndph.ox.ac.uk> > 
Sent: 16 January 2020 14:53
To: Adrian Williamson <adrian.williamson at rationalcommerce.com
<mailto:adrian.williamson at rationalcommerce.com> >;
info-ingres at lists.planetingres.org
<mailto:info-ingres at lists.planetingres.org> 
Subject: RE: [Info-ingres] Dots in Ingres user names?

 

In accessdb you create the username as a double quoted string.

 

Martin Bowes

 

From: Adrian Williamson [mailto:adrian.williamson at rationalcommerce.com] 
Sent: 16 January 2020 14:08
To: info-ingres at lists.planetingres.org
<mailto:info-ingres at lists.planetingres.org> 
Subject: [Info-ingres] Dots in Ingres user names?

 

Hi,

 

I've a number of customers who have Active Directory naming standard that
include forename and surname e.g. Adrian.Williamson

 

Ingres (accessdb) doesn't like this.

 

Is that a difficult thing for the product to do?

 

'adrian.williamson ' is an invalid username or a reserved word.

Legal characters are alphanumerics, '@', '#', '$', and '_'.  The first

character must be alphabetic.  Maximum length is 256 characters.

(E_IC002D)

 

Cheers

 

Adrian

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20200116/b8b2b4ee/attachment.html>