Hello,

as you described, that is exact the same situation for me.

I have users who connect via ODBC and MS Access with an SQL Server Navision DB (SQL Server 2005).

They must...

Hi,

that is exactly what i get too.

The way described is not the right way what i need.

If i deny view definition to a role in a db then the users...

Hello,

i have the same problem. The only solution seems to add then securables as described above or to use the following statement: exec sp_helprotect NULL, 'rolename' or exec sp_helprotect NULL,...

Hello Paul,

you can change it easily by editing a registry-key.

There is a REG_DWORD "Mode", there you can change the value to 2 and you have a processor licensing. (Found in...