When you create a user or database, the system automatically grants you privileges on the created database or user:
- ANY
- CHECKPOINT
- CREATE AUTHORIZATION
- CREATE DATABASE
- CREATE MACRO
- CREATE TABLE
- CREATE TRIGGER
- CREATE USER
- CREATE VIEW
- DELETE
- DROP AUTHORIZATION
- DROP DATABASE
- DROP FUNCTION
- DROP MACRO
- DROP PROCEDURE
- DROP TABLE
- DROP TRIGGER
- DROP USER
- DROP VIEW
- DUMP
- EXECUTE
- INSERT
- SELECT
- STATISTICS (also for creators of tables)
- RESTORE
- UPDATE
These automatic privileges are not granted to the creators of zones.