Authorities and privileges for schema tasks


Task Authorities and privileges
To create a schema with any valid schema name or authorization name You must have SYSADM or DBADM authority. Otherwise, you can create a schema with a schema name or authorization name that matches your authorization ID.
To alter a schema You must be the owner of the schema or you must have one of the following authorities:
  • SYSADM
  • DBADM
To grant privileges for a schema You must have been granted that privilege with the With Grant Option or you must have one of the following authorities:

  • SYSADM

  • DBADM