Skip to Content

Db2 Privileges

As a user, you must have READ/WRITE privileges to the BMC AMI Command Center repository tables. The default CREATOR for these tables is BMCGUD.

Related topics

Planning

After installing verify that BMC AMI Command Center users have EXECUTE privileges to the GUD plan. The default plan name is BMCGUIPL.

Also, verify that users have the privileges required by Catalog Manager. For more information, see Granting access to Catalog Manager functions.

Schema standards and SQL Assurance repository tables

The following table lists the tables used by BMC AMI DevOps Schema Mgmt for Db2 - Schema Standards and BMC AMI SQL Assurance for Db2:

Table name

Description

AMA_RULES

Rule definitions that are tied back to a Rule set

AMA_RULESETS

Groups of Rules

AMA_RULESET_DEP

Reference links between a primary Rule set and other Rule sets

AMA_RULESET_VARS

For future use

AMA_RULE_CONDITIONS

Rule expression and When clauses

AMA_RULE_PICK_LIST

Internal data repository

AMA_RULE_PICK_VAL

For future use

AMA_VIOLATIONS_LOG

Schema and SQL statement violations

AMA_VIOLATIONS_SQLTEXT

SQL text for SQL statement violations

AMA_VIOLATIONS_TO_IGNORE

Rules that ignore violations found within schema and SQL statements

AMA_WORKID_IMPACT

Impact of the WorkID analyzed

AMA_WORKID_IMPACT_OBJ

List of objects within a WorkID that will have certain utilities run against them

Schema standards Db2 privileges

For Schema Standards access, you must grant SELECT privileges to users for the following tables:

  • AMA_RULES
  • AMA_RULESETS
  • AMA_RULESET_DEP
  • AMA_RULE_CONDITIONS
  • AMA_VIOLATIONS_LOG
  • AMA_VIOLATIONS_TO_IGNORE


Sample grant statements
GRANT EXECUTE ON PLAN BMCGUIPL TO PUBLIC ;
GRANT SELECT ON TABLE AMA_RULES TO PUBLIC ;
GRANT SELECT ON TABLE AMA_RULESETS TO PUBLIC ;
GRANT SELECT ON TABLE AMA_RULESET_DEP TO PUBLIC ;
GRANT SELECT ON TABLE AMA_RULE_CONDITIONS TO PUBLIC ;
GRANT SELECT ON TABLE AMA_VIOLATIONS_LOG TO PUBLIC ;
GRANT SELECT ON TABLE AMA_VIOLATIONS_TO_IGNORE TO PUBLIC ;


SQL Assurance Db2 privileges

For SQL Assurance access, you must grant SELECT privileges to users for the following tables:

  • AMA_VIOLATIONS_LOG
  • AMA_VIOLATIONS_SQLTEXT
  • AMA_VIOLATIONS_TO_IGNORE


Sample grant statements
GRANT EXECUTE ON PLAN BMCGUIPL TO PUBLIC ;
GRANT SELECT ON TABLE AMA_VIOLATIONS_LOG TO PUBLIC ;
GRANT SELECT ON TABLE AMA_VIOLATIONS_SQLTEXT TO PUBLIC ;
GRANT SELECT ON TABLE AMA_VIOLATIONS_TO_IGNORE TO PUBLIC ;

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI Command Center for Db2 13.1