ArcMap 10.8.1, Pro 2.7.2 creates the "sde logfile tables as Oracle Global Temporary Tables GTT when make a selection that exceeds the selection threshold, for the "data owner", "editor" and "viewer" users.
We can also manually create the sde logfile tables as GTT, see the support article.
How To: Create log file tables in an enterprise geodatabase as global temporary tables in Oracle
Notes:
Help: Log file tables in geodatabases in Oracle

Help: Create Database User
Creates a database user with privileges sufficient to create data in the database.