Unless specifically stated for a given task, the user does not require database administrator (DBA) privileges.
The following list includes some of the basic privileges that should be granted to the administrative user who creates or modifies the Oracle database:
Assign the user responsible for creating and modifying the Oracle database a specified quota (extent) in the tablespace, even if that user was assigned an unlimited tablespace when created. Otherwise, the installer will generate a "ORA-01950: no privileges on tablespace name" error.
The following list contains basic privileges that should be granted to users who will only run the application.
select 'grant update on '||table_name||' to [user];'
from user_tables
You can write additional scripts to create similar permissions for the following privileges: