Take the 2-minute tour ×
Tridion Stack Exchange is a question and answer site for Tridion developers and administrators. It's 100% free, no registration required.

Do I need to give sys_admin privilege to any users in the database?

It does not seems to be required, please suggest.

Also, apart from the MTSUser (COM user), is there any other user for which I need to give access to the database sever (Deployer/Web)?

List of users need access in database and roles, this is what I am looking for, I am also going through documents available, any suggestion is mostly welcome.

share|improve this question
add comment

2 Answers 2

up vote 5 down vote accepted

Only one user needs database access, and that's the "TCMDBUSER" account. The MTSUser account does not need any database permissions.

In Tridion CM in 2011, you'll have just one user account (default: TCMDBUSER) and in CD you may have multiple users depending on number of databases. None of these users is a "Tridion user", they're purely DB users.

You will need one account with some special privileges (SA in SQL Server, "Tridion_Sys" in Oracle) to create the database, but this user account is not needed anymore once the database is created.

In SQL Server, the TCMDBUSER account only needs Data_Reader and Data_Writer roles, IIRC.

share|improve this answer
    
Many Thanks for your reply. –  Anupam Baksi Feb 20 at 13:35
    
Just one query, TCMDBUSER will require SA privilege in sql sever. Can you please let me know why and what is actually role/responsibility of this user? –  Anupam Baksi Feb 20 at 13:39
    
It does not require SA. It requires SA login to be created (and to create the databases), but the TCMDBUSER account is not an SA. –  Nuno Linhares Feb 20 at 13:44
    
Thanks for the clarification. –  Anupam Baksi Feb 21 at 6:48
add comment

In Addition to Nuno's Answar, you may need 'tcmlogdbuser' a Database account for the Logging database.

for more details, here is the Summary of Tridion user accounts(Login Required) and Content Manager databases security settings (Login Required).

share|improve this answer
    
Just FYI, but starting Tridion 2013 there will be no more Tridion_cm_log DB. Thus, tcmlogdbuser will no longer exist as well –  Robert Jin Feb 20 at 21:08
    
Yes, here it is 2011, I am aware of this and many thanks to all for the information. –  Anupam Baksi Feb 21 at 6:48
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.