I was moved up to super user in Nav and then I could no longer navigate a transaction and show the document
e.g. if in a vendor and I highlight a line and hit the navigate button - I get the sql error
what could they have done to change my ability to view
Note: that we just let go the one person that was here for the implimentation and we have the blind leading the blind
I have an etensive background in Sage products (not that helpful) but if any one knows what they could have done
would re-installing Nav /sql on my personal PC help - it seems everyone else can access but since my change to super user I cannot get into certain areas
You need two roles assigned to you - SUPER and ALL. Only SUPER wouldn’t be enough. But after that you can remove all other roles (if you don’t have any AddOns or custom (non-standart) objects in your database)
As far as I know, this error tells that e.g. a SELECT permission on some object was denied.
Deborah, could you please specify which table was affected? Which “Security Model” do you use in NAV (I recommend “Standard”)? Have you “Synchronized” all Users?
Sometimes you need to grant the SELECT & Co. permission manually (probably some bug) in SQL Management Studio:
USE [my_NAV_DB]
GO
GRANT ALL ON [affected_table_or_view] TO PUBLIC
GO