Implmentation of user security in universe

[Former Member]

Hi,

I need to implement security in designer such that the user should not see all the data that is not relevant to him. The requirement is like this if a manager is handling some projects in region he should only be able to see them for that region and not all the regions.

I am thinking like this, suppose if there is a seperate table existing in database which deals with security and mapped with users access it can be implemented in BO designer with the help of function @variable(BO USER). Can any one please suggest how we can implement in detail.

The BO authentication we are using is 'LDAP'

Thanks,

Eswar

[former_member142702]

Hi

what kind of data sources do you have?

Regards,

Stratos

[Former Member]

Hi,

The database is MS Sql server 2005 and there is a stored procedure created on tables and i need to implement this in universe for the security.

kindly let me know if any information is required on the same.

Thanks,

Eswar.

[former_member142702]

Do you mean that you implement the security on the database using a stored procedure?

Regards,

Stratos