DBDUSER Capabilities and Limitations

The DBDUSER role has the following capabilities and limitations:

When you create a design, you automatically have privileges to manipulate the design. Other tasks may require that the DBDUSER have additional privileges:

To... DBDUSER must have...

Add design tables

  • USAGE privilege on the design table schema
  • OWNER privilege on the design table

Add a single design query

  • Privilege to execute the design query

Add a file of design queries

  • Read privilege on the storage location that contains the query file
  • Privilege to execute all the queries in the file

Add design queries from the result of a user query

  • Privilege to execute the user query
  • Privilege to execute each design query retrieved from the results of the user query

Create the design and deployment scripts

  • WRITE privilege on the storage location of the design script
  • WRITE privilege on the storage location of the deployment script