Development Technology Administrator Testing

Exceptions from DBA Testing

• Objects in STUSTAGE, STUETL and STUHUB are not prefixed by schema name. They are prefixed by other app shortcodes evasys and sits. As this is different frm current standards this needs to be dscussed and agreed by project team and developer/dev tech.
• Table do not have primary or foreign keys. Not sure if this is by design. Rob will fix.
• stuetl has no roles on stuetl objects. Is this required as STUETL not expected to own any tables. This should be OK if all packages will be run by stuetl user. If another user required this will need
• Direct grants on objects to users instead of roles. direct grants to stuetl, stuhub,stustage, bostudmi and bostuhub. Access should be granted via role with exception of stored procedures. 
• Need clarification on role to grant to bostudmin to give access to relevant stuhub objects. at moment direct access to couple of tables.
• Need confirmation testing carried out by users. Etl process run by stuetl. Is universe using bostuhub account. Any other accounts used for testing?
• No public synonyms- confirm if by design not omission. If application designed to reference objects and prefix with schema name this should be OK but we should get agreement. Additional points
• We need to decide if database gateway used to create link to MYSQL evasys database to be setup on test or use version on dev.
• scheduled job(s) for stuetl not been setup or tested.

State Pass or Fail

Awaiting issues being resolved.

State whether:

Requires update to reflect build depends on changes made as part of above feedback.