Warehouse Manager Installation Guide

Setting up authorities and privileges

Warehouse transformers are stored procedures. Before you enable the warehouse transformers, certain authorization levels are needed for the database in which the target warehouse resides. The authorization ID of the statement must hold at least one of the following authorities or privileges:

• SYSADM or DBADM authority
• IMPLICIT_SCHEMA authority on the database, if the implicit or explicit schema name of the procedure does not exist
• CREATEIN privilege on the schema, if the schema name of the procedure refers to an existing schema

To create a fenced stored procedure, no additional authorities or privileges are required.

To create a not-fenced stored procedure, the authorization ID of the statement must also hold one of the following authorities:

• CREATE_NOT_FENCED authority on the database
• SYSADM or DBADM authority