I am having issues when editing an sde feature class from certain users. The way my database is set up is that the authentication roles are updating constantly by comparing the current authentication roles with an LDAP server.
Everything seems to be working fine except for people with user names beginning with a number. I get an error that says "unable to create logfile system tables. User perhaps lacks permissions or resources to create tables [ERROR: syntax error at or near "6" Line 1: CREATE TABLE 6zn.sde_logfiles (logfile_name VARCHAR....)
If the syntax read CREATE TABLE "6zn".sde_logfiles... it would work just fine. Seems like a simple (but scary) solution would be to edit sde functions/triggers/etc. to add quotes for arguments that start with a number in the CREATE TABLE but I have no idea where to start...
Unfortunately, there is no way to get around user names that don't start with numbers.