Permission error in Object<Company Name>$G_L Entry$VSIFT$14'

bestianhow

Hi,
i have facing an error from NAV SP1 as below:

The following SQL Server error(s) occurred while accessing the G/L Entry table:
229,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]The SELECT permission was denied on the object 'Demo Pte Ltd$G_L Entry$VSIFT$14', database 'Demo', schema 'dbo'.

How i can solve this problem?
Thank you very much.

kine

What is "NAV SP1"? ;-)

1) I assume that you are using Extended security model (see File-Alter-last tab-Security model)
2) If 1 is true, you need to synchronize permissions from NAV to SQL - see Tools - Security - Synchronize all

ara3n

Also another option is to change to standard security model.