mibuso.com
Home› SQL General
Options

Problem with SQL Server

hazemhazem Member Posts: 187
edited 2007-03-20 in SQL General
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?

Comments

  • Options
    lubostlubost Member Posts: 615
    What exactly system tells you?
  • Options
    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'.
  • Options
    lubostlubost Member Posts: 615
    I think that you have not DB_OWNER permissions in SQL server.
  • Options
    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.
  • Options
    krikikriki Member, Moderator Posts: 9,089
    [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.