Schema administration authority (SCHEMAADM)

SCHEMAADM authority is the administrative authority for a specific schema. The schema administrator has the required privilege to create and manage objects in a schema.

SCHEMADM authority can only be granted or revoked by a user holding database SECADM or database ACCESSCTRL authority or schema ACCESSCTRL authority. It can be granted to a user, a group, or a role. However, it cannot be granted with grant option or be granted on any schema whose name begins with the "SYS". Additionally, PUBLIC cannot obtain the SCHEMAADM authority directly or indirectly through a role.

Having the SCHEMAADM authority on a schema gives a user the following privileges on that schema:

• Create, alter, and drop non-security related schema objects
• Reorganize indexes/tables in the schema
• Use RUNSTATS utility on tables defined in the schema
• Bind privilege on packages defined in the schema
• Schema LOAD authority

The authority is the subset of the database DBADM authority with its scope limited only to the schema on which it is granted.