Frank Chiang

In Intranet and Extranet situations when I use AD, I can permit a whole group of AD users to use BDC and that simplifies administration; but in Internet situation when I use ASP.NET 2.0 membership and role providers that access a database store, I don't know how to do it. I can assign each single user permission but I think I should be able to assign a role permission so that all users with that role will be permitted. But I can't find a way to permit a role because I can't see roles (I can see users) in Users/Group Picker. Any ideas

Re: SharePoint - Business Data Catalog Manage BDC Permissions in Internet Situation

ggilboa

Hi Frank,

How can you assign each single user permission when you use form authentication

the ssp web site is window authentication and it can't recorgnize users from ASP.NET 2.0 membership did you set your ssp site to

form authentication also

thank's alot

guy





Re: SharePoint - Business Data Catalog Manage BDC Permissions in Internet Situation

Frank Chiang

Hi Guy,

Yes. I set the ssp site to use form authentication and I still haven't figured out how to set a role permission for BDC entities. Setting individual user permission to entities works but is really not very practical in real life situation. Hopefully someone from MSFT can show a solution.





Re: SharePoint - Business Data Catalog Manage BDC Permissions in Internet Situation

ggilboa

Hi Frank,

i don't know how to set a role permission but i think that you can define a users group in sharepoint and configure each webpart

audience for that group. this is enough for you

the problem is that you have to configure each webpart.

maybe you can use the nt authority/authenticated users and configure that users to execute permission and special users to other

permissions

by the way did you configure your bdc to dispaly data for anonymous users how can i do it

guy





Re: SharePoint - Business Data Catalog Manage BDC Permissions in Internet Situation

jcuervo

I have exactly the same issue. I have a BDC application that pulls data from SQL2005 that works fine for authenticated users but I can't get to work for anonymous users. Any advise on the the best methods and practices to enable anonymous access to BDC web parts and data would be greatly appreciated.

Thanks,

-Jim






Re: SharePoint - Business Data Catalog Manage BDC Permissions in Internet Situation

Frank Chiang

Guy, Turn out that it is just a deficiency of the picker. For sql database form access, you have to put in the role name exactly, otherwise it won't show up. But in AD, you can put in part of the name and the picker will show a list of matches.

Regarding anonymous access to BDC. It looks like it is not doable, but I am not sure.





Re: SharePoint - Business Data Catalog Manage BDC Permissions in Internet Situation

Nick Swan

couple of options to get BDC working for anonymous access.

1, Set the application pool running as a domain account, and also the anonymous user account as a domain account. Make sure these accounts have access to the SQL Server and set the app def file to RevertToSelf as the authentication mode.

2, actually pass in the SQL user Id and password you want to connect as

<Property Name="DatabaseAccessProvider" Type="System.String">SqlServer</Property>
<Property Name="AuthenticationMode" Type="System.String">PassThrough</Property>
<Property Name="RdbConnection Data Source" Type="System.String">servername</Property>
<Property Name="RdbConnection Initial Catalog" Type="System.String">Database Name goes here</Property>
<Property Name="RdbConnection User ID" Type="System.String">Username goes here</Property>
<Property Name="RdbConnection Password" Type="System.String">Password goes here</Property>
<Property Name="RdbConnection Integrated Security" Type="System.String" />
<Property Name="RdbConnection Pooling" Type="System.String">False</Property>

Hope this helps

Nick