Workaround for username size limitation.
802810Dec 2 2011 — edited Jan 9 2012Hi,
We are currently trying to enable external authentication for our users in to a Oracle database. But we are having a problem because our OS usernames are longer than the limit of 30 characters.
Is there any workaround for this ? can this be done ?
I have heard that we could set a sort of Alias to a externally identified user. (e.g CREATE USER TESTUSERA IDENTIFIED EXTERNALLY AS longDomain\longusername)
Will this work for normal windows authentication or does it need Kerberos or any other mechanism?
Thanks.