SDE Error with Editor Tracking

[MichaelVolz]

I implemented Editor Tracking on a v10.2 SDE feature class with 2 of the 4 fields. The initial edit of a feature worked where the SDE username was entered automatically as well as the date. Unfortunately after saving the changes, closing the edit session and then opening a new edit session I received the following error when trying to view the attribute table:

"Could not load data from the data source. If you can correct the problem, press the refresh button to reload data. Possible problems can include bad network connection, invalid field, etc.
Unable to create logfile system tables. User perhaps lacks permissions or resources to create tables [ORA-01031: insufficient privileges]."

Has anyone encountered this issue and know of the solution?

Any help or hints are greatly appreciated.

[AsrujitSengupta]

Michael,

The user seems to be lacking enough permissions to create the logfiles.
The following permissions are required to use shared log file tables in Oracle:
CREATE SESSION
CREATE TABLE
CREATE SEQUENCE
(The default ArcSDE log file table configuration for Oracle is shared ArcSDE log files.)

The log file are created in the schema of the connecting user the first time the user makes a selection that exceeds the selection threshold. For ArcGIS for Desktop, this threshold is 100 records.

Log file table configuration options for geodatabases in Oracle(10.1)
http://resources.arcgis.com/en/help/main/10.2/index.html#//002n00000014000000

Note: If you don't want that user to have those permissions in the long run, grant those permissions--> Select more than 100 records in ArcMap (logfiles will be created)--> Revoke the permissions.

Regards,