In order to perform data definition tasks, you must have the appropriate authority.
With DBA authority, you can perform all data definition tasks. You also can grant authority to other users to perform specific tasks. This includes the ability to grant DBA authority to other users.
To create any database object, you need resource authority for that type of object.
When you create an object you become its owner. The owner of an object automatically has authority to perform all operations on that object, and to grant other users authority to update the information in a table.
The DBA and object owners can grant authority to individual users and to groups of users. For complete information, see Chapter 12, “Managing User IDs and Permissions” You can also use the -gu command-line option to set the permission level required to create or delete a database.
