I’m having some issues with the CURRENT_USER method in our SDE environment… My DynamicValue table is stored in SDE, owned by our LGIM schema, and in turn is loaded into my edit MXD using the LGIM user credentials (in order to make it editable as I tweak things iteratively, etc.). The data I'm testing against is a RoadCenterline feature class which is also stored in SDE, owned by our TRANSPORTATION schema, and subsequently loaded into my edit MXD under my user credentials, hitting an edit version.
I configured the DynamicValue table to populate a Creator field in RoadCenterline using the CURRENT_USER method, w/ On Create = True, and using the 'D' parameter in the Value Info to pull the username from the current database user. However, when a new segment/feature is added, my results have been varied (but never correct😞 the Creator field is either left null, or is populated with 'LGIM'. I'm not sure how either value is possible, given that the connected user editing the dataset in question is never the LGIM user...
If I specify the 'W' option for ValueInfo field, I do get the correct Windows User, but that defeats my purpose.
Has anyone run into similar difficulties with this?
#CURRENT_USER