From: Raman on
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
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
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
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