|
Home > Archive > Commerce Server General > June 2006 > CS2007 Select Permission Denied
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
CS2007 Select Permission Denied
|
|
| Michael Rouleau 2006-06-25, 7:32 pm |
| any ideas?
Microsoft.CommerceServer.ServerFaultException: SELECT permission denied on
object 'mktg_industry_code', database 'CSharpSite_marketing', schema 'dbo'.
---> System.Web.Services.Protocols.SoapException:
System.Web.Services.Protocols.SoapException: SELECT permission denied on
object 'mktg_industry_code', database 'CSharpSite_marketing', schema 'dbo'.
---> Microsoft.CommerceServer.ServerFaultException: SELECT permission denied
on object 'mktg_industry_code', database 'CSharpSite_marketing', schema 'dbo'.
--- End of inner exception stack trace ---
at
Microsoft.CommerceServer.Marketing.WebService.MarketingWebService. PropagateOrLogExceptionInternal(Exceptio
n except)
at
Microsoft.CommerceServer.Marketing.WebService.MarketingWebService.PropagateOrLogException(Exception except)
at
Microsoft.CommerceServer.Marketing.WebService.MarketingWebService.ExecuteSearchWithCount(String
entityType, XmlElement searchClause, SearchOptions searchOptions, Boolean
includePerformanceData, Int32& recordsMatched)
at
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters)
at
Microsoft.CommerceServer.Internal.Marketing.MarketingServiceProxy.AuthorizedInvoke(String methodName, Object[] parameters)
--- End of inner exception stack trace ---
at
Microsoft.CommerceServer.ServiceAgent.TryHandleWebMethodException(Exception
ex, SoapHttpClientProtocol serviceProxy)
at
Microsoft.CommerceServer.Internal.Marketing.MarketingServiceProxy.AuthorizedInvoke(String methodName, Object[] parameters)
at
Microsoft.CommerceServer.Internal.Marketing.MarketingServiceProxy.ExecuteSearchWithCount(String
entityType, XmlElement searchClause, SearchOptions searchOptions, Boolean
includePerformanceData, Int32& recordsMatched)
at
Microsoft.CommerceServer.Internal.Marketing.AgentMarketingSystemImpl.ExecuteSearch(String
entityType, XmlElement searchClause, SearchOptions searchOptions, Boolean
includePerformanceData, Int32& recordsMatched)
at Microsoft.CommerceServer.Marketing.CustomerManager.Search(SearchClause
clause, SearchOptions searchOptions, Int32& recordsMatched)
at
Microsoft.CommerceServer.UI.MarketingManager.CustomerCache.GetData(SearchClause clause, SearchOptions options, Int32& recordsMatched)
at
Microsoft.CommerceServer.UI.MarketingManager.MarketingCache.GetDataAndAddColumns(SearchClause searchClause, SearchOptions options, Int32& totalRecords)
at
Microsoft.CommerceServer.UI.MarketingManager.MarketingCache.PopulateCache(Int32 absoluteIndex)
| |
| David Hargis [MSFT] 2006-06-27, 7:16 pm |
| Your MarketingWebService does not have sufficient priviliges to the
CSharpSite_marketing database. Make sure the identity of this web service
is a member of the mktg_marketingService_role on the CSharpSite_marketing
database, and dbo on the CSharpSite_marketing_lists database.
- David
--------------------
Thread-Topic: CS2007 Select Permission Denied
thread-index: AcaYiN0S4HIJU9yOS0eEMJPkd4290g==
X-WBNR-Posting-Host: 24.62.115.230
From: =?Utf-8?B?TWljaGFlbCBSb3VsZWF1?=
<MichaelRouleau@discussions.microsoft.com>
Subject: CS2007 Select Permission Denied
Date: Sun, 25 Jun 2006 11:55:01 -0700
Lines: 47
Message-ID: <D2A3F315-A5F2-4F36-A2D7-8BE5AFB984E6@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
Newsgroups: microsoft.public.commerceserver.general
Path: TK2MSFTNGXA01.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:17959
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
X-Tomcat-NG: microsoft.public.commerceserver.general
any ideas?
Microsoft.CommerceServer.ServerFaultException: SELECT permission denied on
object 'mktg_industry_code', database 'CSharpSite_marketing', schema 'dbo'.
---> System.Web.Services.Protocols.SoapException:
System.Web.Services.Protocols.SoapException: SELECT permission denied on
object 'mktg_industry_code', database 'CSharpSite_marketing', schema 'dbo'.
---> Microsoft.CommerceServer.ServerFaultException: SELECT permission
denied
on object 'mktg_industry_code', database 'CSharpSite_marketing', schema
'dbo'.
--- End of inner exception stack trace ---
at
Microsoft.CommerceServer.Marketing.WebService.MarketingWebService.PropagateO
rLogExceptionInternal(Exception except)
at
Microsoft.CommerceServer.Marketing.WebService.MarketingWebService.PropagateO
rLogException(Exception except)
at
Microsoft.CommerceServer.Marketing.WebService.MarketingWebService.ExecuteSea
rchWithCount(String
entityType, XmlElement searchClause, SearchOptions searchOptions, Boolean
includePerformanceData, Int32& recordsMatched)
at
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClient
Message message, WebResponse response, Stream responseStream, Boolean
asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters)
at
Microsoft.CommerceServer.Internal.Marketing.MarketingServiceProxy.Authorized
Invoke(String methodName, Object[] parameters)
--- End of inner exception stack trace ---
at
Microsoft.CommerceServer.ServiceAgent.TryHandleWebMethodException(Exception
ex, SoapHttpClientProtocol serviceProxy)
at
Microsoft.CommerceServer.Internal.Marketing.MarketingServiceProxy.Authorized
Invoke(String methodName, Object[] parameters)
at
Microsoft.CommerceServer.Internal.Marketing.MarketingServiceProxy.ExecuteSea
rchWithCount(String
entityType, XmlElement searchClause, SearchOptions searchOptions, Boolean
includePerformanceData, Int32& recordsMatched)
at
Microsoft.CommerceServer.Internal.Marketing.AgentMarketingSystemImpl.Execute
Search(String
entityType, XmlElement searchClause, SearchOptions searchOptions, Boolean
includePerformanceData, Int32& recordsMatched)
at
Microsoft.CommerceServer.Marketing.CustomerManager.Search(SearchClause
clause, SearchOptions searchOptions, Int32& recordsMatched)
at
Microsoft.CommerceServer.UI.MarketingManager.CustomerCache.GetData(SearchCla
use clause, SearchOptions options, Int32& recordsMatched)
at
Microsoft.CommerceServer.UI.MarketingManager.MarketingCache.GetDataAndAddCol
umns(SearchClause searchClause, SearchOptions options, Int32& totalRecords)
at
Microsoft.CommerceServer.UI.MarketingManager.MarketingCache.PopulateCache(In
t32 absoluteIndex)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Note: For the benefit of the community-at-large, all responses to this
message are best directed to the newsgroup/thread from which they
originated.
| |
| Michael Rouleau 2006-06-28, 7:17 pm |
| Got it, thanks david
"David Hargis [MSFT]" wrote:
> Your MarketingWebService does not have sufficient priviliges to the
> CSharpSite_marketing database. Make sure the identity of this web service
> is a member of the mktg_marketingService_role on the CSharpSite_marketing
> database, and dbo on the CSharpSite_marketing_lists database.
>
> - David
>
> --------------------
> Thread-Topic: CS2007 Select Permission Denied
> thread-index: AcaYiN0S4HIJU9yOS0eEMJPkd4290g==
> X-WBNR-Posting-Host: 24.62.115.230
> From: =?Utf-8?B?TWljaGFlbCBSb3VsZWF1?=
> <MichaelRouleau@discussions.microsoft.com>
> Subject: CS2007 Select Permission Denied
> Date: Sun, 25 Jun 2006 11:55:01 -0700
> Lines: 47
> Message-ID: <D2A3F315-A5F2-4F36-A2D7-8BE5AFB984E6@microsoft.com>
> MIME-Version: 1.0
> Content-Type: text/plain;
> charset="Utf-8"
> Content-Transfer-Encoding: 7bit
> X-Newsreader: Microsoft CDO for Windows 2000
> Content-Class: urn:content-classes:message
> Importance: normal
> Priority: normal
> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
> Newsgroups: microsoft.public.commerceserver.general
> Path: TK2MSFTNGXA01.phx.gbl
> Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:17959
> NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
> X-Tomcat-NG: microsoft.public.commerceserver.general
>
> any ideas?
>
> Microsoft.CommerceServer.ServerFaultException: SELECT permission denied on
> object 'mktg_industry_code', database 'CSharpSite_marketing', schema 'dbo'.
> ---> System.Web.Services.Protocols.SoapException:
> System.Web.Services.Protocols.SoapException: SELECT permission denied on
> object 'mktg_industry_code', database 'CSharpSite_marketing', schema 'dbo'.
> ---> Microsoft.CommerceServer.ServerFaultException: SELECT permission
> denied
> on object 'mktg_industry_code', database 'CSharpSite_marketing', schema
> 'dbo'.
> --- End of inner exception stack trace ---
> at
> Microsoft.CommerceServer.Marketing.WebService.MarketingWebService.PropagateO
> rLogExceptionInternal(Exception except)
> at
> Microsoft.CommerceServer.Marketing.WebService.MarketingWebService.PropagateO
> rLogException(Exception except)
> at
> Microsoft.CommerceServer.Marketing.WebService.MarketingWebService.ExecuteSea
> rchWithCount(String
> entityType, XmlElement searchClause, SearchOptions searchOptions, Boolean
> includePerformanceData, Int32& recordsMatched)
> at
> System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClient
> Message message, WebResponse response, Stream responseStream, Boolean
> asyncCall)
> at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> methodName, Object[] parameters)
> at
> Microsoft.CommerceServer.Internal.Marketing.MarketingServiceProxy.Authorized
> Invoke(String methodName, Object[] parameters)
> --- End of inner exception stack trace ---
> at
> Microsoft.CommerceServer.ServiceAgent.TryHandleWebMethodException(Exception
> ex, SoapHttpClientProtocol serviceProxy)
> at
> Microsoft.CommerceServer.Internal.Marketing.MarketingServiceProxy.Authorized
> Invoke(String methodName, Object[] parameters)
> at
> Microsoft.CommerceServer.Internal.Marketing.MarketingServiceProxy.ExecuteSea
> rchWithCount(String
> entityType, XmlElement searchClause, SearchOptions searchOptions, Boolean
> includePerformanceData, Int32& recordsMatched)
> at
> Microsoft.CommerceServer.Internal.Marketing.AgentMarketingSystemImpl.Execute
> Search(String
> entityType, XmlElement searchClause, SearchOptions searchOptions, Boolean
> includePerformanceData, Int32& recordsMatched)
> at
> Microsoft.CommerceServer.Marketing.CustomerManager.Search(SearchClause
> clause, SearchOptions searchOptions, Int32& recordsMatched)
> at
> Microsoft.CommerceServer.UI.MarketingManager.CustomerCache.GetData(SearchCla
> use clause, SearchOptions options, Int32& recordsMatched)
> at
> Microsoft.CommerceServer.UI.MarketingManager.MarketingCache.GetDataAndAddCol
> umns(SearchClause searchClause, SearchOptions options, Int32& totalRecords)
> at
> Microsoft.CommerceServer.UI.MarketingManager.MarketingCache.PopulateCache(In
> t32 absoluteIndex)
>
>
>
>
> --
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
>
> Note: For the benefit of the community-at-large, all responses to this
> message are best directed to the newsgroup/thread from which they
> originated
|
|
|
|
|