+

Search Tips   |   Advanced Search

Database users


Database administration user

Permission within the database domain 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


Database runtime user

Permission within the database domain 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


Parent: Database considerations