Suppose the database administrator needs to create a Finance and Administration (F&A) department database with user Jones as a supervisory user—that is, as database administrator in the F&A department.
The database administrator first creates database F&A and then allocates space from it to user Jones to act as the F&A database administrator. The database administrator also allocates space from F&A to Jones for his personal use and for creating database Personnel and other databases and other user space allocations. The following figure shows the hierarchy implicit in this relationship:
F&A database owns Personnel database and all the other department databases.
F&A Database also owns user Jones and all other users in the department.
Because user DBC owns all databases and users, it is the final owner of all databases and user space belonging to the organization.
This hierarchical ownership structure provides an owner of a database or user space with complete control over the security of owned data. An owner can archive the database or control access to it by granting or revoking privileges on it.