[Info-ingres] Dots in Ingres user names?

[Adrian Williamson]

Last thought:

 

When editing the config.dat by hand to put in users with server control
capabilities I take it I'd use quotes there too?

 

ii.sergni.privileges.user."Adrian.Williamson":
SERVER_CONTROL,NET_ADMIN,MONITOR,TRUSTED

 

Apologies for asking rather than just doing but I don't have an Ingres 11
installation to hand that I can play with.

 

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.

 

Cheers

 

Adrian

 

From: info-ingres-bounces at lists.planetingres.org
<info-ingres-bounces at lists.planetingres.org> On Behalf Of Adrian Williamson
Sent: 16 January 2020 15:24
To: 'Martin Bowes' <martin.bowes at ndph.ox.ac.uk>;
info-ingres at lists.planetingres.org
Subject: Re: [Info-ingres] Dots in Ingres user names?

 

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
<mailto:adrian.williamson at rationalcommerce.com> > 
Sent: 16 January 2020 15:19
To: 'Martin Bowes' <martin.bowes at ndph.ox.ac.uk
<mailto:martin.bowes at ndph.ox.ac.uk> >; 'info-ingres at lists.planetingres.org'
<info-ingres at lists.planetingres.org
<mailto: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/6cbde386/attachment.html>