Document toolboxDocument toolbox

Creating an Oracle Database User

Owned by Matthew Wren
Jan 29, 2024
1 min read

Related Pages:

 

A User should be created with the following recommendations/requirements in mind...

 

Recommendations/requirements

The following recommendations are intended as a guide when creating the database for the first time. Note that these are minimum values and may need to be increased for some installations. The actual values used need to be discussed with the business users and your ServicePower consultant.

 Value
temporary tablespace, TEMP

at least 300Mb

  • Factors affecting this are:
  • the number of jobs per day per operative
  • the number of days worth of job data that you wish to keep
  • the auditting level in use
  • the amount of historic auditting data you wish to keep
undo tablespace

at least 100Mb

This is affected by similar factors as above.

database initialisation parameters
  • 100 processes
  • Date Format set to ‘DD-MON-YY’
redo log groupsAt least two should be created using different physical disk volumes for protection against media failure
database user permissions
  • Alter session
  • Create procedure
  • Create sequence
  • Create session
  • Create synonym
  • Create table
  • Create trigger
  • Create view
privileges

Select privilege on v$session

1. V$SESSION is a synonym; to give access the user also needs select privilege on the underlying object, SYS.V_$SESSION.

2. The select access needs to be granted explicitly.  This can be either via a grant statement specifying the particular user, or via one granting the access to 'public'.  However, it is not adequate for the privilege to be acquired implicitly by the user via the granting of a role.

 

For further requirements see ServiceOptimizer Pre-Requisites

Â