Changing Ownership of Databases and Database Objects
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 Security Guide.
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.
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.