| Task
| Authorities and privileges
|
| To add, change, or delete a comment on an alias
| You must be defined to DB2 as the creator of the alias, or you must have
one of the following authorizations:
- SYSADM authority
- DBADM authority on the database in which the alias is stored
- The ALTERIN privilege on the schema to which the alias belongs
|
| To create an alias
| You need authorization in one of these forms:
- SYSADM authority
- DBADM authority on the database in which you want the alias stored
- One of two rights that apply to schemas:
- If you want to use the Create Alias window to create the alias's
schema, you need the IMPLICIT_SCHEMA authority on the database in which you
want the alias stored.
- If you want to assign the alias to an existing schema, you need the
CREATEIN privilege on that schema.
|
| To drop an alias
| You must be defined to DB2 as the creator of the alias, or you must have
one of the following authorizations:
- SYSADM authority
- DBADM authority on the database in which the alias is stored
- The DROPIN privilege on the alias's schema
|