Changing Ownership of Databases and Database Objects

At times it may be necessary to change the ownership of a database or database object, for example, when staff changes occur in your organization.

This chapter includes instructions for changing the owner of a database or database object if change at the schema level is necessary.

Changing the ownership of the following database objects is discussed:

• Tables
• Applications
• Forms
• Reports
• Databases

Database Ownership

Ingres supports an ownership scheme for databases, the tables that make up the database, and related database objects, including forms and reports.

The hierarchy of ownership involves the following user classes:

• The primary system administrator
• The DBA
• The end user

Each class has a different set of ownership privileges. For details, see the chapters "Authorizing User Access" and "Ensuring Access Security."

Two important rules of database ownership are:

• Objects cannot be shared among users, unless they have been granted access to the objects.
• Objects cannot be shared between databases.