Database user for repository (MSS)

[Steve James]

Hi, what's the minimum permissions that the repository account needs on an MS SQL database?

We're not happy giving it dbo as it allows the account to do too much in the event of a hack.

Thanks

[Jon]

The Ebase server just issues selects, updates, inserts and deletes. An upgrade may additionally issue creates and drops. As long as these permissions are configured it should work fine.

[Steve James]

Thanks Jon