Error 229 - Permission denied

dulaman

Hi

I am upgrading a Navision 3.70 database to Dynamics NAV 5.01SP.

My method is a bit rude but it works: first, I create a native backup of the original database (in a fbk file). Then, I create a new database in NAV 5, and from there I restore the old database.

Well, all seems to work fine: all functions are restored and the new db works in NAV 5 like a charm... except... I am the only one who can access to the database!!

The rest of the users receive this error: 229, "42000" [Microsoft][ODBC SQL Server Driver][SQL Server] The SELECT permission was denied on the object 'Permission', database 'test5' schema 'dbo'.

The only way I've found to grant access to the rest of users is giving them the "owner" status, which is, obviously, not what I want to do.

I am pretty sure that there is something very obvious that I am missing to do in SQL, but... what?? ](*,)

mohana_cse06

Did you synchronize all users?

dulaman

mohana_cse06 wrote:

Did you synchronize all users?

Yes of course, first thing I did after the restoration. NAV already asks if you want to do so, and I did it.

mohana_cse06

Did you also try to excecute below query?

use [Your_NAV_Database]
go
grant select on [Object] to public
go

dulaman

mohana_cse06 wrote:

Did you also try to excecute below query?

use [Your_NAV_Database]
go
grant select on [Object] to public
go

Aaand... it worked! Thank you very much! =D>

I was trying this:

use mydatabase
go
grant select on Permission to USER
go

And it was not working. I wonder why it works for all but not for one. In any case, I still wonder why I must grant permissions for this specific table after the restoration?

Anyway, thanks again mohana_cse06 !!

kriki

Instead of using Enhanced security model and then synchronizing the users, it is easier (and better to use the standard Security Model).