You must have at least one of the following privileges to
create a table:
- CREATETAB privilege on the database and either:
- IMPLICIT_SCHEMA authority on the database if the implicit or explicit
schema name of the table does not exist
- CREATEIN privilege on the schema if the schema name of the table exists
- SYSADM or DBADM authority
To define a foreign key, you must have at least one of the following
privileges on the foreign table:
- REFERENCES privilege on the table
- CONTROL privilege on the table
- SYSADM or DBADM authority
[ Top of Page |
Table of Contents |
Glossary |
Index ]
[ DB2 List of Books |
Search the DB2 Books ]