for stand alone log file for ArcSDE (check this: http://resources.arcgis.com/en/help/main/10.2/index.html#//002n0000001400000000under "Permissions required for stand-alone log files", permissions required are:
- CREATE SESSION
- CREATE TABLE
- CREATE TRIGGER
- CREATE SEQUENCE
- CREATE PROCEDURE
or you can grant "resource" oracle role to the user.Regards,