A user has permission to see all cutomers apart from one

dareme76

I have a request where by a user has to be able to see all navision customers apart from one. The Database is SQL Server 2005 ... i thought of modifying a view in SQL, and once they are using windows authentication i would combine that too BUT how would i then link the functionality to navision.

The client wants to be able to give users access to navision clients on a need to know basis.

Thanks

rakeshbudarapu

In role u can set the table filter.

Roles -> Permission -> Security Filter.

dareme76

THANKS FOR YOUR REPLY, BUT WHEN I SET THE PERMISSION NAVISION TELLS ME
"YOU DO NOT HAE PERMISSION TO OPEN THE OBJECT TABLE".

THE TABLE I AM WORKING ON IS TABLE 18 CUSTOMERS.

IN PERMISSIONS WHAT I AM ACTUALLY DOING IS SELECTING OBJECT 18 AND THEN I SET READ & MODIFY TO YES AND FINALLY SELECT THE SECURITY FILTER SETTING CUSTOMER NO. =<> 10000 THUS I WILL NOT BE ABLE TO SEE THIS CUSTOMER USING THIS ROLE.

THANKS ONCE AGAIN

kriki

Please, no need to yell. (if someone writes all text in uppercase, it means he is yelling)