conditional drilldown

sample 1.

IF "Item Category Code"<>'MISC' THEN
BEGIN
ILE.SETFILTER(ILE."Item No.","No.");
ILE.SETFILTER(ILE."Global Dimension 1 Code","Global Dimension 1 Filter");
ILE.SETFILTER("Global Dimension 2 Code","Global Dimension 2 Filter");
ILE.SETFILTER("Location Code","Location Filter");
ILE.SETRANGE("Drop Shipment","Drop Shipment Filter");
ILE.SETFILTER("Variant Code","Variant Filter");
ILE.SETFILTER("Lot No.","Lot No. Filter");
ILE.SETFILTER("Serial No.","Serial No. Filter" );
frmILE.SETTABLEVIEW(ILE);
frmILE.RUN;
END
ELSE  ;

This works fine but this Restriction is only for the "End Users" but the "Managers" want to see the Item Ledger Entries for all Item Categories i.e this restriction should not apply to them.


I started with
1.Creating a user called MISCUSER in SQL SERVER 2005 and then Synchronized the Users from NAV CLIENT.
2.Created a new ROLE called MISC ROLE and copied all the permissions from the "SUPER" Role except for the Table "Item" where i first tried to make the Permission as "Blank" and then "Indirect".
3.Wrote the Following code
sample 2.

SETPERMISSIONFILTER;

If READPERMISSION THEN

  MESSAGE('You have some read permissions to item.')

ELSE

  MESSAGE('You have no read permission to item.');

4. I was expecting for the MISCUSER login when i run the item card it should show me MESSAGE('You have no read permission to item.');
but it shows
MESSAGE('You have some read permissions to item.')

5.So i tried to Syncronize ALL Logins i get an error "229,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server] Select permission denied on object '$ndo$usrproperty',databse 'demo',schema 'dbo'"

6.Iam trying to accomplish this scenario
when Manager logs in he can see the item card and he can change the item category code and drill down on inventory
but the "end users" down should be restricted as shown in code sample 1 above


Any help much appreciated ,thanks!