Problem with SQL Server

hazemhazem Member Posts: 187
edited 2007-03-20 in SQL General

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?


  • lubostlubost Member Posts: 607
    What exactly system tells you?
  • hazemhazem Member Posts: 187
    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'.
  • lubostlubost Member Posts: 607
    I think that you have not DB_OWNER permissions in SQL server.
  • kinekine Member Posts: 12,562
    As Lubost wrote, you need to be at least DB_OWNER to be able to change table definitions on MS SQL.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • krikikriki Member, Moderator Posts: 9,079
    [Topic moved from Navision forum to SQL General forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Sign In or Register to comment.