Well ... usually a DBMS won't be run by the root user
but via a service account, e.g postgres for PostgreSQL, oracle
for Oracle, and so forth... from then on it all depends on
whom you grant access to those privileged users accounts,
and how you administer each DBMS internally in terms of
permissions (e.g grants on internal tablespaces).