SQL 2k5 Problem(Unable to modify)

sanjeev_baranwal
sanjeev_baranwal Member Posts: 101
edited 2007-12-05 in SQL General
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.

Comments

  • kine
    kine Member Posts: 12,562
    1) Version of NAV
    2) Standard or Extended security model?
    3) Did you run the Synchronize all in security?
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • NaviDev
    NaviDev Member Posts: 365
    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.
    Navision noob....
  • sanjeev_baranwal
    sanjeev_baranwal Member Posts: 101
    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
    sanjeev_baranwal Member Posts: 101
    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
    matteo_montanari Member Posts: 189
    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
    Reno Sistemi Navision Developer
  • sanjeev_baranwal
    sanjeev_baranwal Member Posts: 101
    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
    kine Member Posts: 12,562
    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...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • kriki
    kriki Member, Moderator Posts: 9,121
    sanjeev baranwal wrote:
    1) Version of NAV - 4.0 SP1

    And do a client upgrade to at least 4.00SP3 Upgrade 6.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • kriki
    kriki Member, Moderator Posts: 9,121
    [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!

  • sanjeev_baranwal
    sanjeev_baranwal Member Posts: 101
    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.

Categories