DBDUSER capabilities and limitations

The DBDUSER role has the following capabilities and limitations:.

The DBDUSER role has the following capabilities and limitations:

  • A DBDUSER cannot create a design with a K-safety less than the system K-safety. If the designs violate the current K-safety by not having enough buddy projections for the tables, the design does not complete.

  • A DBDUSER cannot explicitly change the ancient history mark (AHM), even during deployment of their design.

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

To... DBDUSER must have...
Submit design tables
  • USAGE privilege on the design table schema

  • OWNER privilege on the design table

Submit a single design query
  • Privilege to execute the design query
Submit 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

Submit 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