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.
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.
The following table lists the tables used by BMC AMI Command Center:
| Table name | Description |
|---|---|
| CONNECTIONS | Named Db2 connections created by users. A named connection can be private or public and can also access remote subsystems defined in the Db2 LOCATIONS table. |
| CONNECTIONS_USED | Administrative information to track connections used by workspaces |
| FOLDERS | Folders created by users to organize templates |
| TEMPLATES | Templates (workspace copies) created by users to share with others. You can use a template to create a new workspace that replicates the original. |
| USER_PREFERENCES | User preferences and settings that BMC AMI Command Center saves automatically while you use it |
| WORKSPACES | Workspaces that users created. A workspace can contain a variety of views, data, and settings depending on the product features used. |
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
The default creator for these tables is BMCAMA. 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
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
The default creator for these tables is BMCAMA. 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
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 ;