Permission Error while modifying Table 112

te6

Hi All,

I logged into the DB in SQL. with windows login. when I tried to change the length of Address filed in table 112 an error was coming.

ERROR::

---

Microsoft Dynamics NAV Classic

---

The following SQL Server error or errors occurred when accessing the Sales Invoice Header table:

1088,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot find the object "CRONUS India Ltd_$Sales Invoice Header" because it does not exist or you do not have permissions.

SQL:
ALTER TABLE "MK Agro Delivarable"."dbo"."CRONUS India Ltd_$Sales Invoice Header" ALTER COLUMN "Bill-to Address" VARCHAR(75) NOT NULL

---

OK

---

But when I logged through database server authentication, and tried to change the length of Address field in table 112. it is accepting the change.


I didn't understand why like this. please suugest me...

Shedman

It seems to me that your DB login has different rights than your Windows login. Check the security settings for both users.

te6

hi Shedman,

thanks for the reply..

I have checked. Both,the database Login and windows login has super right only..

kine

Because one account is db_owner or sysadmin on the SQL server and the second is not... ;-)

kriki

[Topic moved from 'NAV 2009' forum to 'SQL General' forum]