SQL 2k5 Problem(Unable to modify)

sanjeev_baranwal

Dear All,
When I am modifying anythin in the database from one machine to the SQL server 2005 based Database then I recived the error message that 'You dont have permission to modify the database.Ctact your administrator'. Also when I create new users and giving them the super permission then error message comes that ' You dont have permission fot Table 0'. When I have taken the backup and then restored in in a local mcahine then everything is going fine. Can anyone please suggest me what is going wrong. Thanks in advance.

kine

1) Version of NAV
2) Standard or Extended security model?
3) Did you run the Synchronize all in security?

NaviDev

If you are using AD check your user where group does it belong?

I personally experience this when I used the user with limited rights like guest.

sanjeev_baranwal

1) Version of NAV - 4.0 SP1
2) Standard or Extended security model - standard
3) Did you run the Synchronize all in security? - Yes

sanjeev_baranwal

NaviDev wrote:

If you are using AD check your user where group does it belong?

I personally experience this when I used the user with limited rights like guest.

In SQL I have given it the Role db_Owner

matteo_montanari

sanjeev baranwal wrote:

1) Version of NAV - 4.0 SP1
2) Standard or Extended security model - standard
3) Did you run the Synchronize all in security? - Yes

hi

Standard? Are you sure?
Standard is available only on version prior to 3.70 and 4Sp3. Not on 4sp1

Eto

sanjeev_baranwal

Dear Eto,
I have done nothing extra in Security so I thought that it is standard. My Mistake. By the way can you please tell me the difference between these two.I think I should know it also.

kine

I recommend to read "Security Synchronization in Navision 4.0 SP3.doc" which is available on NAV 4.00SP3 install CD.

Main thing is: Extended security means one application role for each user. Standard means one application role for all users. Extended means that synchronisation of the permissions can take loooong time (e.g. 40 minutes) but is needed to have working permissions. Standard mean that you nearly do not need to synchronise the permissions...

kriki

sanjeev baranwal wrote:

1) Version of NAV - 4.0 SP1

And do a client upgrade to at least 4.00SP3 Upgrade 6.

kriki

[Topic moved from Navision forum to SQL General forum]

sanjeev_baranwal

kriki wrote:

sanjeev baranwal wrote:

1) Version of NAV - 4.0 SP1

And do a client upgrade to at least 4.00SP3 Upgrade 6.

Hi All,
My Problem solved in the following way. I taken backup from SQL again restored in local machine. After that I removed many users and kept few users with permissions of Super(In SQL I was not able to give permissions even with the super login from the Navision Application). Then I have taken backup of the local datatabse and restored it on SQL server 2k5 and it worked.