Problem with SQL Server

hazem

Hello,

I want to integrate a FOB on a sql server database and i got an error telling me that i can't modify the table "Country"...I thought it's due to user role but i'm connected with a SUPER user that have all permissions!

What can be the problem?

lubost

What exactly system tells you?

hazem

the error message is in french but i'll try to translate :roll:

This SQL Server errors occured when access the Country table:

3704,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]User is not authorized to make this operation on table 'CompanyName$Country'.

lubost

I think that you have not DB_OWNER permissions in SQL server.

kine

As Lubost wrote, you need to be at least DB_OWNER to be able to change table definitions on MS SQL.

kriki

[Topic moved from Navision forum to SQL General forum]