December 31, 2007 at 12:36 pm
I had a problem with Business Objects XI not being able to read from its audit database. Thinking... when I initially configured the database, I had assigned the following rights to the application role 'boxi':
- db_datareader
- db_datawriter
- db_ddladmin
- public - it was already checked and I thought it was prudent to 'leave' it
I had presumed that by allowing 'db_ddladmin' would be sufficient for Business Objects. I'm not sure why having the above roles Business Objects did not initially create the auditing tables it uses.
In any case I updated 'db_owner' to the 'boxi' role, which should allow the role to 'carry out any activity'.
Further information on database roles at: http://www.databasejournal.com/features/mssql/article.php/1441261
December 31, 2007 at 1:31 pm
Thanks for sharing, but please post in the appropriate forum for your product and issue.
This has been moved to the Express forum.
January 1, 2008 at 6:24 am
Sorry
January 3, 2008 at 10:26 am
Jon (12/31/2007)
... when I initially configured the database, I had assigned the following rights to the application role 'boxi':- db_datareader
- db_datawriter
- db_ddladmin
- public - it was already checked and I thought it was prudent to 'leave' it
In any case I updated 'db_owner' to the 'boxi' role, which should allow the role to 'carry out any activity'.
Further information on database roles at: http://www.databasejournal.com/features/mssql/article.php/1441261
FWIW, did you attempt to identify which of the other roles might apply to provide the privileges you require? Or perhaps other settings that needed to be changed? I presume that adding db_owner worked, so it's sufficient. But is it necessary as well?
January 3, 2008 at 12:44 pm
No, basically that's what I wanted to find out 🙂
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply