Access Denied to DB

Brendan Broughton
Brendan Broughton Active Partner
Third Anniversary 100 Comments 100 Up Votes 25 Likes
edited April 2020 in Platform

Hi, I am Admin of a clients BOARD DB.  I was amending security levels and adding a new DB Security Profile as requested by the client, and after clicking OK I can no longer access the DB myself.  I made no change to my security level or my DB security profile so I am not sure why it has locked me out. I now get the following message whenever I try to access the DB.

 

I have tried unloading the DB and restarting the service with no luck.

 

image

 

I have then tried copying the DB to a different server to see what I could do and I am not even able to restore it there.

 

Because of time constraints I will have to go to a backedup version, but how would you resolve this without the backup?

Answers

  • Dear Brendan Broughton,

     

    only valid way running into the described condition is, that you had overwritten the DB security profile linked to your security profile.

     

    The only way to solve is manually add another DB Profile to your securtiy profile.

     

    For that reason we suggest creating BACKUPs before doing security relevant changes.

     

    Hope it helps.

     

    regards

     

    Alexander Kappes