Required Database Permissions for Tridion 2013

Question

I am providing a SQL Server for Tridion 2013. I don't have the installation media yet, but I understand this will create the database logins and users. Could anyone tell me the minimum permissions required on the database for these objects. I would like to apply as little permissions as required.

Answer 1

The documentation for database server pre-requisites is available HERE. For installation and configuration of the content manager database, Tridion recommends a MTSUser. Configuration of SQL server is available HERE.

I would also note that Tridion uses a database for Content Data Store (Tridion Broker) and also Experience Manager (WYSIWYG editor).

Installation is typically done using PowerShell. Hope it helps!

Answer 2

It depends a bit on which databases you will be responsible for. In any case, the installation scripts will grant default permissions and the minimum requirements are documented in various 'database security' sections of the documentation. For example:

• Content Manager database security settings
• Audience Manager and Outbound E-mail database security settings