limit access to a reports data

[gshadz37]

I thought I read somewhere a while ago that it's possible to run one report, and give access to multiple people, but only allow them to see the data that pertains to them. Is that possible? Does anyone know where to find the documentation on it?

 

[synapsevampire]

It's possible, but it depends upon technical details, such as your SOFTWARE, it's VERSION, the DATABASE used, and what security model you intend to use.

-k

 

[gshadz37]

CE/CR10, Oracle 8i, looking for suggestions on the security model.

 

[synapsevampire]

If you have security in the database, try to leverage it's tables.

There are numerous approaches to security, I would suggest that you speak with your technical people, such as the dba to learn if they have user/roles types of security tables.

Then each query might leverage them in the joins, the only trick being to pass along the users login info.

Otherwise it's fairly complex.

-k

 

[synapsevampire]

I forgot that you can use Business Views in CE 10, that's probably the best way for you to go if your database doesn't have this level of security within.

Check out:

http://www.businessobjects.com/pdf/products/crystalenterprise/CE_Business_Views.pdf

-k

 

[gshadz37]

That's what I was looking for, Thanks.