Allowing the DBDUSER to run Database Designer programmatically

To allow a user with the DBDUSER role to run Database Designer programmatically, take these steps:

1. The DBADMIN user must grant the DBDUSER role:

   => GRANT DBDUSER TO <username>;
   

   This role persists until the DBADMIN user revokes it.

2. For a non-DBADMIN user to run the Database Designer programmatically or using Management Console, one of the following two steps must happen first:

   • If the user's default role is already DBDUSER, skip this step. Otherwise, The user must enable the DBDUSER role:

     => SET ROLE DBDUSER;
     

   • The DBADMIN must add DBDUSER as the default role for that user:

     => ALTER USER  DEFAULT ROLE DBDUSER;