Oracle database user privileges

Unless specifically stated for a given task, the user does not require database administrator (DBA) privileges.

Oracle administrator 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.

Oracle privileges for application users

The following list contains basic privileges that should be granted to users who will only run the application.

The Privileges/Grant is only for the tables owned by the user. The following is an example script to create table update grants:
select 'grant update on '||table_name||' to [user];'
from user_tables

You can write additional scripts to create similar permissions for the following privileges: