Who Can Run Database Designer
To use Administration Tools to run Database Designer and create an optimal database design, you must be a DBADMIN user.
To run Database Designer programmatically or using Management Console, you must be one of two types of users:
- DBADMIN user
- Have been assigned the DBDUSER role and be the owner of database tables for which you are creating a design