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.
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.
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).
