Authorities and privileges for accessing remote data sources


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

  • CREATETAB privilege

The authorization ID must also map to an authorization ID that will allow you to access both the table and the data source system catalog. If you don't have a mapping to either catalog, create one with the CREATE USER MAPPING statement or the Create User Mapping window.

To create nicknames Your authorization ID for the local database must hold one of the following permissions:

  • SYSADM authority

  • DBADM authority

  • CREATETAB privilege