Some users of the database manager are authorized to create and manage their own set of tables. There are two ways you can obtain the authority to create and manage your own tables. You may have RESOURCE authority, or you may ask someone with DBA authority to acquire a dbspace on your behalf. The latter lets you create tables in a private dbspace only (dbspaces are discussed later in this chapter.)
To determine what authority you have, type:
select resourceauth from sqldba.sysuserlist - where name = user
A Y under RESOURCEAUTH indicates that you have resource authority and can create and manage your own set of tables.
You can use the following sections if you have resource authority. They describe how to manage your own tables, share them with other users, and improve query performance.