Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Can Dotnetnuke run without dbowner?Can Dotnetnuke run without dbowner?
Previous
 
Next
New Post
3/5/2008 9:05 PM
 

i have a question, after dotnetnuke installation and completed to build the website... Can Dotnetnuke run without dbowner?

can it run as other roles for example, db_securityadmin
db_ddladmin
db_datareader
db_datawriter

 
New Post
3/6/2008 9:15 AM
 

It can, you can download the documentation (documentation is still 4.4.1, but it applies here) and look for the section about running it will lesser permissions.  It has a very detailed section about how to set it up with "minimal" permissions but allow it to do it's job.


-- Jon Seeley
DotNetNuke Modules
Custom DotNetNuke and .NET Development
http://www.seeleyware.com
 
New Post
3/7/2008 3:33 AM
 

Thank you, i find it out in Installation Guide.pdf

The databaseOwner attribute is used to identify the user that “owns” the database objects. By default it is set to “dbo” and in most cases this attribute should be left this way. However, some SQL Server DBAs (in particular in Shared Hosting Environments) may not grant the user you identify in the connection string db_owner privileges. In this case, set the databaseOwner attribute to your login user. Note this user will need to have the following SQL Permissions, at a minimum:

  • db_datareader (necessary for dotnetnuke)
  • db_datawriter (necessary for dotnetnuke) 
  • db_ddladmin (neccessry for MemberRoles) 
  • db_securityadmin (necessary during installation of MemberRoles) 

The previous two settings are only relevant for the default MS SQL Server Data Provider. If you are using an alternate data provider, you will have to refer to its documentation to configure the provider properly.

 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Can Dotnetnuke run without dbowner?Can Dotnetnuke run without dbowner?


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out