Database administration users

Database users

There are two types of database users:

database configuration users
database runtime users

Database configuration user

Typically created when a DBMS is installed. Database installation user or the database configuration user. The database configuration user is not necessarily the user created by default when the database management system is installed. The default user could be used as the database configuration user. The database configuration user is used by WebSphere Portal for ConfigEngine tasks, and creates the database structure needed by WebSphere Portal. For example, the database configuration user can create database tables and indexes, perform database transfer, and often has operating system privileges.

Database runtime user

Fewer privileges than the database configuration user. Has runtime access to the data source of a database. Can perform basic read and write operations on the data. Consider creating a dedicated runtime user for each database domain of WebSphere Portal. If we do not create runtime users, then WebSphere Portal uses the configuration user to connect to the databases at runtime.

Privileges of database users

Permission Release Community Customization JCR Feedback Likeminds
Access to the database Yes Yes Yes Yes Yes Yes
Read on all tables Yes Yes Yes Yes Yes Yes
Write on all tables Yes Yes Yes Yes Yes Yes
Update on all tables Yes Yes Yes Yes Yes Yes
Delete on all tables Yes Yes Yes Yes Yes Yes
Create tables No No No Yes No No
Create indexes No No No Yes No No
Use of sequences No No No Yes Yes No
Access to the database Yes Yes Yes Yes Yes Yes
Read on all tables Yes Yes Yes Yes Yes Yes
Write on all tables Yes Yes Yes Yes Yes Yes
Update on all tables Yes Yes Yes Yes Yes Yes
Delete on all tables Yes Yes Yes Yes Yes Yes
Quota on disk to create new objects Yes Yes Yes Yes Yes Yes
Create table spaces Yes Yes Yes Yes Yes Yes
Drop table spaces Yes Yes Yes Yes Yes Yes
Create tables Yes Yes Yes Yes Yes Yes
Alter tables Yes Yes Yes Yes Yes Yes
Drop tables Yes Yes Yes Yes Yes Yes
Create indexes Yes Yes Yes Yes Yes Yes
Drop indexes Yes Yes Yes Yes Yes Yes
Create triggers Yes Yes Yes No Yes Yes
Drop triggers Yes Yes Yes Yes Yes Yes
Create sequences No No No Yes Yes No
Use of sequences No No No Yes Yes No
Create types No No No Yes No No
Drop types No No No Yes No No
Create views No No No No No No
Drop views No No No Yes No No

Parent Database

Permission	Release	Community	Customization	JCR	Feedback	Likeminds
Access to the database	Yes	Yes	Yes	Yes	Yes	Yes
Read on all tables	Yes	Yes	Yes	Yes	Yes	Yes
Write on all tables	Yes	Yes	Yes	Yes	Yes	Yes
Update on all tables	Yes	Yes	Yes	Yes	Yes	Yes
Delete on all tables	Yes	Yes	Yes	Yes	Yes	Yes
Create tables	No	No	No	Yes	No	No
Create indexes	No	No	No	Yes	No	No
Use of sequences	No	No	No	Yes	Yes	No
Access to the database	Yes	Yes	Yes	Yes	Yes	Yes
Read on all tables	Yes	Yes	Yes	Yes	Yes	Yes
Write on all tables	Yes	Yes	Yes	Yes	Yes	Yes
Update on all tables	Yes	Yes	Yes	Yes	Yes	Yes
Delete on all tables	Yes	Yes	Yes	Yes	Yes	Yes
Quota on disk to create new objects	Yes	Yes	Yes	Yes	Yes	Yes
Create table spaces	Yes	Yes	Yes	Yes	Yes	Yes
Drop table spaces	Yes	Yes	Yes	Yes	Yes	Yes
Create tables	Yes	Yes	Yes	Yes	Yes	Yes
Alter tables	Yes	Yes	Yes	Yes	Yes	Yes
Drop tables	Yes	Yes	Yes	Yes	Yes	Yes
Create indexes	Yes	Yes	Yes	Yes	Yes	Yes
Drop indexes	Yes	Yes	Yes	Yes	Yes	Yes
Create triggers	Yes	Yes	Yes	No	Yes	Yes
Drop triggers	Yes	Yes	Yes	Yes	Yes	Yes
Create sequences	No	No	No	Yes	Yes	No
Use of sequences	No	No	No	Yes	Yes	No
Create types	No	No	No	Yes	No	No
Drop types	No	No	No	Yes	No	No
Create views	No	No	No	No	No	No
Drop views	No	No	No	Yes	No	No