search cancel

Registry tables cannot be accessed: permission denied

book

Article ID: 6957

calendar_today

Updated On:

Products

CA Application Test CA Continuous Application Insight (PathFinder)

Issue/Introduction

 Starting VSE and getting permission issue that the Registry tables cannot be accessed.  Registry logs shows  the below message. 

CREATE TABLE permission denied in database 'REGISTRY_DB' 



Cause

The Devtest user for the Registry database did not have permissions to create tables.    



Environment

All supported version and platforms of DevTest.

Resolution

 DBA gave CREATE privilege to the User ID starting the DevTest services. 

Additional Information

There were some space issues on the REGISTRY_DB, so the DBA  changed the recovery model  from Full to Simple, this will mean that there won't be log backups at all so it will stop that logfile from filling up again. However, if log files wanted, then it can be changed back to the Full recovery model and will need to set up regular log backups.