Salesforce

What are the differences between a database administrator and a database owner?

« Go Back

Information

 
TitleWhat are the differences between a database administrator and a database owner?
URL NameP93079
Article Number000155990
EnvironmentProduct: Progress
Version: 9.x
Product: OpenEdge
Version: 10.x, 11.x
OS: All supported platforms
Question/Problem Description
What is a database administrator (DBA)?
Who is the database owner?
What are the differences between a database administrator and a database owner?
Steps to Reproduce
Clarifying Information
Error Message
Defect Number
Enhancement Number
Cause
Resolution
The database owner is the operating system user that created the database. The database administrator (DBA) is an individual that has been granted administrator rights within the database.

DBA rights may be granted using the GUI Data Administration tool with the menu option "Admin > Security > Security Administrators..."., or the character Procedure Editor with the menu option "Tools > Data Dictionary > Admin > Security > Security Administrators...".

SQL DBA privileges can granted using SQL GRANT statements in a SQL query tool such as SQL Explorer.

Being a SQL DBA does not make the user a 4GL/ABL security administrator, or vice versa.

A database can have only one database owner, but it may have several database administrators.

The database owner is the default database administrator. The default DBA cannot have its privileges revoked using 4GL or SQL.
Workaround
Notes
Keyword Phrase
Last Modified Date11/20/2020 7:29 AM

Powered by