Db_owner is the one you want.
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hodges, Kristen Sent: Monday, 4 February 2008 4:53 PM To: [email protected] Subject: RE: [OzMOSS] Changing the Identity of the Central Administration account Im going from memory here (and its been a while!) . So I could have missed something. CREATE DATABASE & MANAGE SECURITY on the login and DB_OWNER on the database itself From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Daniel Brown Sent: Monday, 4 February 2008 4:47 PM To: [email protected] Subject: RE: [OzMOSS] Changing the Identity of the Central Administration account Hi Kirsten, What permission does it require on the existing database? dbowner? Cheers, Daniel From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hodges, Kristen Sent: Monday, 4 February 2008 4:06 PM To: [email protected] Subject: RE: [OzMOSS] Changing the Identity of the Central Administration account Yes you will need to explicitly give the account access to the database From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Daniel Brown Sent: Monday, 4 February 2008 4:33 PM To: [email protected] Subject: [OzMOSS] Changing the Identity of the Central Administration account Hi all, Im looking at changing the identity of the Central admin IIS Application pool and have a couple of questions regarding the existing database permissions. The account in AD and SQL server is all setup fine with the correct permissions (domain user, local admin, dbcreator, securityadmin). My question is, what sort of ownership and/or access permissions will this account need for the existing databases? Does the permissions need changing at all or will SharePoint do that automatically? Sorry If I havent explained it clear, If I havent, please feel free to ask for more information and details. - Adelaide SharePoint User group - http://www.aspug.org.au (Comming Soon!) - My Blog: http://www.danielbrown.id.au ý Please consider the envrionment before printing this email. ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by www.readify.net ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by www.readify.net ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by www.readify.net ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by www.readify.net ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by www.readify.net
