Development Technology Administrator Testing

 

 

 

Exceptions from DBA Testing

    There are 2 areas that failed: object naming conventions and indexes in the wrong tablespace.

 

Link to completed DBA test review document: O:\projects\areas\itservices\corporateinf\ITS095\secure\its095_dbaChecks.docx

 

 

State : Fail.  I've fixed the problem with the indexes being in the wrong tablespace. The only remaining fail is the table naming convention, However it looks as if this schema is used for a number of purposes and these are consistent naming conventions e.g. tables have TS_, IDM_, FH_ prefixes. One point to note is that there are no GRANTS on any tables. There is aslo a step that need to be confirmed by a developer or the project manager.