When you create a user or database, it automatically gets the following privileges on itself:
- ANY
- CHECKPOINT
- CREATE AUTHORIZATION
- CREATE MACRO
- CREATE TABLE
- CREATE TRIGGER
- CREATE VIEW
- DELETE
- DROP AUTHORIZATION
- DROP FUNCTION
- DROP MACRO
- DROP PROCEDURE
- DROP TABLE
- DROP TRIGGER
- DROP VIEW
- DUMP
- EXECUTE
- INSERT
- SELECT
- STATISTICS
- RESTORE
- UPDATE
These same privileges are automatically given to creators, with the exception of CREATE USER, CREATE DATABASE, DROP USER, and DROP DATABASE.