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!

databaseOwner

Return to previous page

  • 4/7/2015
  • 4913 Views

Comments

4913 Views

databaseOwner

Last updated 9 years ago

Comments

Common

(Enter the content of this article below)

Advanced

 

The databaseOwner is an optional parameter of the SqlDataProvider value.

In SQL Server 2000, the databaseOwner attribute was used to identify the user that “owns” the database objects.
In SQL Server 2005 and later it is the name of the Database Schema being used to create the database objects in.
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)
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out