Restrict View data access to some users only.

Hi All ,

I need a help from the experts!

First of all , is it possible to create two view with same name?

Let's try to explain...

Today i have one view that store data for a period of 1 year and i have some clients that access these data. I want to restrict this period to 6 months only , but only to one client (for example Client application A). For example , through the Client A today i can check the bills from a periof of one year , but i want to restrict to 6 month , so the Client A will be allowed to check only bills from 6 months.

So i was thinking to create another view with the same name with condition to store data only for a period of 6 month .

I don't know how to make that only users from Client Application A access this new view.

I have a table that stores all users that access the client application A.

Any other suggestions to restrict the Client A access to period of 6 month only without creating new view wil help me a lot!

TIA! rgds, Received on Sat Nov 18 2006 - 04:17:28 CST