Access Control in BIM

From Sage Intelligence Knowledgebase
Jump to: navigation, search

Question

If I have the Administrator Module,can I deny access for a certain users not to have access to certain containers in the Administrator Module.

Answer

Don't use BIM but there is a trick that you can use that would limit Container access to specific users by manipulating the Source Containe Join.

Using a Pastel Evolution container as my example.

(([_bvSTTransactionsFull]

LEFT JOIN [StkItem]

ON [_bvSTTransactionsFull].[AccountLink] = [StkItem].[StockLink])

LEFT JOIN [TrCodes]

ON [_bvSTTransactionsFull].[TrCodeID] = [TrCodes].[idTrCodes])

WHERE '@SYSTEMUSER@' IN ('Fred','Bob')

Adding "WHERE '@SYSTEMUSER@' IN ('Fred','Bob')" to the end of the join will result in ONLY Fred and Bob having access to the contents of the container.

Fred and Bob being the "MSWindows" System USER Names

You could also try WHERE '@WORKSTATION@' IN ('FredsPC','BobsPC') instead

- where FredsPC and BobsPC are the actual system Workstation names allocated to their specific PC's