DBO rights for NAV

wwestendorp

Hi,

If a user go's to the Sales Module, Sales Order he receives a message that his user account and /or passord is not okay.
If we give him just DBO rights on the Database it works.
We have a view which will be checked(data) when opening that Form.

Why does the user needs DBO rights or how can we modify this so the users have Normal SQL Rights?

Regards,

William :shock:

garak

grant this view the the right public

like

use [Your_NAV_Database]
go
Grant Select on [dbo].[CompanyName$View] to public
GO

Regards

wwestendorp

Yep tried this but no effect.

I can see the Form opening and then direct after the message that the useraccount is not okay.

We allready changed the security model to standard without a positive result.

How can we set PUBLIC rights to all tables and views in a DB with an SQL Script?

kine

1) DBO is not needed
2) Can you post exact error text?
3) Did you synchronize permissions after you changed the security mode?