Tom Conlon wrote:

I've just run into a serious problem with the above

domainname= 16 characters
domainuser= firstname.lastname (common format) = 16 characters

so, grant arole to "domainnamedomainuser" fails (too long) In this case, the domainname is slightly longer than usual but this means that all domain user names would have to be limited to 15 characters. If they use the dot notation to separate first.last name then it becomes only 14 characters.

Paul Beach replied:

Currently the maximum is 31 characters (like any other Firebird identifier) and 15ch/15ch is usually the norm.

In Fireird 3 it will be possible to map - more or less like MS SQL does - logins (16/16 or even longer) to some internal name and then CURRENT_USER will be set to that internal name.

Like this post? Share on: TwitterFacebookEmail

Related Articles


Firebird Community



Gems from Firebird Support list