Prev: error in a site navigation webpart (Ch.Ugszrh.Webparts)
Next: UpdateListItems returns error 0x80020005
From: Raman on 8 Apr 2006 10:05 Hi, I have Microsoft SharePoint question that someone might have answer for. I have Windows Server 2003, SharePoint portal, Business Intelligence (BI) portal, and Analysis Service installed on same PC. I have one admin login (administrator) and other non-admin logins (user1, user2) created. In Analysis Service cube, I have two roles (role and role2) that have access to only certain dimensions in cube. Added user1 to role1 and user2 to role2. When I browse cube using Analysis service, this role based security is working fine and data is viewed as per security permissions for user1 and user2. On SharePoint, I have created a Business Intelligence (BI) Portal that accesses the same cube as outlined above. I am logging into machine as Administrator and logging onto IIS/SharePoint as User1. However, when I browse the cube through SharePoint/BI Portal, my role based security defined in analysis service for user1 is not working and I get to see all data. Instead, I should be able to see only that data that user1 has access to because I am connecting to IIS/SharePoint as user1 (logged onto machine as administrator though). If I login machine as user1 (and not administrator), login to IIS/SharePoint as user1 and then view cube through SharePoint-BI Portal, I see only that data that user1 has access to. So, the security is not working when login to machine as administrator but login to IIS/SharePoint as user1/user2. Does anyone know how to impose role based security in SharePoint/BI Portal even if I logged onto machine as administrator? ~Raman
From: Engelbert on 8 Apr 2006 10:23 This is the newsgroup for Windows SharePoint Services. You'll find the SharePoint Portal Server 2003 newsgroup at microsoft.public.sharepoint.portalserver (Not that I imagine that even there there will be many people with this combination on the same server - but hopefully when you post there you'll explain which Business Intelligence portal you have installed) Engelbert "Raman" <Raman(a)discussions.microsoft.com> wrote in message news:10C8B207-EA9F-4A7D-B32A-98D57147DD16(a)microsoft.com... > Hi, > > I have Microsoft SharePoint question that someone might have answer for. > > I have Windows Server 2003, SharePoint portal, Business Intelligence (BI) > portal, and Analysis Service installed on same PC. I have one admin login > (administrator) and other non-admin logins (user1, user2) created. In > Analysis Service cube, I have two roles (role and role2) that have access > to > only certain dimensions in cube. Added user1 to role1 and user2 to role2. > When I browse cube using Analysis service, this role based security is > working fine and data is viewed as per security permissions for user1 and > user2. > > On SharePoint, I have created a Business Intelligence (BI) Portal that > accesses the same cube as outlined above. I am logging into machine as > Administrator and logging onto IIS/SharePoint as User1. However, when I > browse the cube through SharePoint/BI Portal, my role based security > defined > in analysis service for user1 is not working and I get to see all data. > Instead, I should be able to see only that data that user1 has access to > because I am connecting to IIS/SharePoint as user1 (logged onto machine as > administrator though). > > If I login machine as user1 (and not administrator), login to > IIS/SharePoint > as user1 and then view cube through SharePoint-BI Portal, I see only that > data that user1 has access to. So, the security is not working when login > to > machine as administrator but login to IIS/SharePoint as user1/user2. > > Does anyone know how to impose role based security in SharePoint/BI Portal > even if I logged onto machine as administrator? > > ~Raman
From: Raman on 10 Apr 2006 12:23 Hi, I am using windows sharepoint services. I am using Business Intelligence Portal (BIP) template (by microsoft) for creating a site. BIP uses Office Web Components (OWC). -- Raman "Engelbert" wrote: > This is the newsgroup for Windows SharePoint Services. > > You'll find the SharePoint Portal Server 2003 newsgroup at > > microsoft.public.sharepoint.portalserver > > (Not that I imagine that even there there will be many people with this > combination on the same server - but hopefully when you post there you'll > explain which Business Intelligence portal you have installed) > > Engelbert > "Raman" <Raman(a)discussions.microsoft.com> wrote in message > news:10C8B207-EA9F-4A7D-B32A-98D57147DD16(a)microsoft.com... > > Hi, > > > > I have Microsoft SharePoint question that someone might have answer for. > > > > I have Windows Server 2003, SharePoint portal, Business Intelligence (BI) > > portal, and Analysis Service installed on same PC. I have one admin login > > (administrator) and other non-admin logins (user1, user2) created. In > > Analysis Service cube, I have two roles (role and role2) that have access > > to > > only certain dimensions in cube. Added user1 to role1 and user2 to role2. > > When I browse cube using Analysis service, this role based security is > > working fine and data is viewed as per security permissions for user1 and > > user2. > > > > On SharePoint, I have created a Business Intelligence (BI) Portal that > > accesses the same cube as outlined above. I am logging into machine as > > Administrator and logging onto IIS/SharePoint as User1. However, when I > > browse the cube through SharePoint/BI Portal, my role based security > > defined > > in analysis service for user1 is not working and I get to see all data. > > Instead, I should be able to see only that data that user1 has access to > > because I am connecting to IIS/SharePoint as user1 (logged onto machine as > > administrator though). > > > > If I login machine as user1 (and not administrator), login to > > IIS/SharePoint > > as user1 and then view cube through SharePoint-BI Portal, I see only that > > data that user1 has access to. So, the security is not working when login > > to > > machine as administrator but login to IIS/SharePoint as user1/user2. > > > > Does anyone know how to impose role based security in SharePoint/BI Portal > > even if I logged onto machine as administrator? > > > > ~Raman > > >
From: Robin Meuré on 11 Apr 2006 03:43
I have no experience with the BI webpart stuff (but soon i will!! ;)) but it seems to me that the analysis services use the credentials that are in SQL Server right? With Sharepoint/IIS you use the application pool to connect to the database therefore using an admin account. That's probably the case here also. Can't you define user credentials in the webparts? "Raman" wrote: > Hi, > > I have Microsoft SharePoint question that someone might have answer for. > > I have Windows Server 2003, SharePoint portal, Business Intelligence (BI) > portal, and Analysis Service installed on same PC. I have one admin login > (administrator) and other non-admin logins (user1, user2) created. In > Analysis Service cube, I have two roles (role and role2) that have access to > only certain dimensions in cube. Added user1 to role1 and user2 to role2. > When I browse cube using Analysis service, this role based security is > working fine and data is viewed as per security permissions for user1 and > user2. > > On SharePoint, I have created a Business Intelligence (BI) Portal that > accesses the same cube as outlined above. I am logging into machine as > Administrator and logging onto IIS/SharePoint as User1. However, when I > browse the cube through SharePoint/BI Portal, my role based security defined > in analysis service for user1 is not working and I get to see all data. > Instead, I should be able to see only that data that user1 has access to > because I am connecting to IIS/SharePoint as user1 (logged onto machine as > administrator though). > > If I login machine as user1 (and not administrator), login to IIS/SharePoint > as user1 and then view cube through SharePoint-BI Portal, I see only that > data that user1 has access to. So, the security is not working when login to > machine as administrator but login to IIS/SharePoint as user1/user2. > > Does anyone know how to impose role based security in SharePoint/BI Portal > even if I logged onto machine as administrator? > > ~Raman |