| Task
| Authorities and privileges
|
| To create a wrapper or a server specification
| Your authorization ID for the local database must hold either SYSADM or
DBADM authority on the database.
|
| To create user mapping
| Your authorization ID for the local database must hold one of the
following permissions:
- SYSADM authority
- DBADM authority
|
| To create nicknames
| Your authorization ID for the local database must hold one of the
following permissions:
- SYSADM or DBADM authority
- CREATETAB authority on the database and one of:
- IMPLICIT_SCHEMA authority on the database, if the implicit or explicit
schema name of the table does not exists
- CREATEIN privilege on the schema, if the schema name of the table refers
to an existing scheme
|