The role is automatically created on the <sitename>_profiles database when
you unpack CSharp.pup or Starter.pup.
- David
--------------------
From: "Colin Bowern" <***@hotmail.com>
References: <28E1698D-69E4-4030-9AE7-***@microsoft.com>
Subject: Re: SQL Definitions for Schema roles
Date: Sun, 5 Nov 2006 01:34:07 -0500
Keywords: < Not Specified >
Lines: 25
Message-ID: <5CF0F044-A68B-46F5-8238-***@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
format=flowed;
charset="iso-8859-1";
reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Live Mail desktop 8.0.1083
X-MimeOLE: Produced By Microsoft MimeOLE V8.0.1083
X-MS-CommunityGroup-PostID: {5CF0F044-A68B-46F5-8238-278490D29ACE}
X-MS-CommunityGroup-ThreadID: 28E1698D-69E4-4030-9AE7-AA57178CFAA8
X-MS-CommunityGroup-ParentID: 28E1698D-69E4-4030-9AE7-AA57178CFAA8
Newsgroups: microsoft.public.commerceserver.userprofilemgt
Path: TK2MSFTNGXA01.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl
microsoft.public.commerceserver.userprofilemgt:3686
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 127.0.0.1
X-Tomcat-NG: microsoft.public.commerceserver.userprofilemgt
And I found it tucked away in a not so obvious place:
C:\Program Files\Common Files\Microsoft Shared\Enterprise Servers\Commerce
Server\CatalogSchema.sql
It looks like whoever was doing the packaging should really consider
packaging all SQL files together in the SiteCreate folder.
Cheers,
Colin
Post by Colin BowernI can't seem to locate the SQL definition files for the following roles in
* Profile_Schema_Manager
* Profile_Schema_Reader
Did I totally miss them because they aren't in ProfileSQL.sql, yet
magically they come out of the Starter Site and CSharpSite Package?
Thanks,
Colin
--
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.