Database users
Database configuration user
The database administration user that is typically created when a database management system (DBMS) is installed is the database installation user or the database configuration user. The database configuration user is not necessarily the user that is created by default when the database management system is installed. The default user might be used as the database configuration user. The database configuration user is used by HCL WebSphere Portal for configuration tasks and creates the database structure that is needed by HCL WebSphere Portal. For example, the database configuration user can create database tables and indexes, do database transfer, and often times has operating system privileges, depending on the database management system.
Database runtime user
The database runtime user has fewer privileges than the database configuration user. The runtime user has runtime access to the data source of a database and can do basic read and write operations on the data. Consider creating a dedicated runtime user for each database domain of HCL WebSphere Portal. If we do not create runtime users, then HCL WebSphere Portal uses the configuration user to connect to the databases at run time.
Privileges of database users
Privileges held by database runtime 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 No No No Create indexes No No No No No No Use of sequences No No No No Yes No
Privileges held by database configuration 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 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 topic: Database
References: