level of permission on database account

[FrankArthurIII]

Hi All!

About to install RoboHelp Server 8.

We've created a SQL database and a RoboHelp username and password for that database.

For the install of RoboHelp Server 8 I'm assuming the db account needs DBO permissions (full owner).

Our DBA group however does not like leaving accounts with DBO permission.

After install can the level of permission for the database account be lowered? to say modify or read/write?

Thanks for the info!

Frank

[RoboColum_n_ · Accepted solution]

Hi Frank and welcome to the RH forums.

When you first start the RHS it is not connected to the DB. You have to specify logon details for a user with full admin rights. This is used to create an Admin group and user complete with various permissions so the admin rights are definitely used there. You'd then be creating other users, groups, permissions requiring admin rights on the logon.

Perhaps (I'm not sure) that you could get away with read/write access if all you were doing was maintaining areas, running reports, etc. However you'd have to get admin rights each time you need to create/amend/delete users or contexts. Personally I wouldn't have thought it was worth the hassle.

If you go back to your DBA and remind them that only you has access to the Config Manager where the DB security can be compromised, would this appease them?

---

The RoboColum(n)

@robocolumn

Colum McAndrew

[FrankArthurIII]

Colum, Great info on the what functions require different db rights. Thanks!

Frank

[FrankArthurIII]

Thanks again for the reply and welcome Colum,

Quick followup... Our DBA asked if DB_security_admin or DB_DDL_admin rights will work for the database account instead of db owner?

[RoboColum_n_]

Yikes! Now you are skirting onto territory that I know nothing about. Let me ask the question to those who may know the answer and I'll post back when I have the answer. That should be on Monday. Hope that's OK.

---

The RoboColum(n)

@robocolumn

Colum McAndrew