[Info-ingres] Dots in Ingres user names?

[Martin Bowes]

I'd be hesitant about using dots as it makes for a confusing "owner".table syntax.

I'd dread seeing something like "tom.dick.harry".table

Marty

From: Adrian Williamson [mailto:adrian.williamson at rationalcommerce.com]
Sent: 16 January 2020 15:19
To: Martin Bowes; 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>
Sent: 16 January 2020 14:53
To: Adrian Williamson <adrian.williamson at rationalcommerce.com>; 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/69267c60/attachment.html>