locked
User permissions on schema automatically changed hence principal database is not accessible? RRS feed

  • Question

  • Hi All,

    We have SQL Server 2012 on which a database if configured for mirroring and working fine but all of a sudden application couldn't connect to the principal database with an error (password did not match that for the login provided)

    When it is analysed permission on schema is altered to some other schema hence the issue is occurred and resolved when it is set back.

    Without any manually intervention how could it change the schema to default .dbo

    Please share your views on this. Thank You

    Regards,

    Kalyan


    Grateful to your time and support. Regards, Shiva

    Friday, July 25, 2014 8:45 AM

Answers

  • There might be manual change or may some other automated tasks might be involved, like agent jobs SP's triggers, application end codes etc..

    Raju Rasagounder Sr MSSQL DBA

    • Marked as answer by tracycai Tuesday, July 29, 2014 9:52 AM
    Friday, July 25, 2014 11:06 AM
  • The permissions wont get automatically changed by any means. There should be a user intervention either manually or through some code (job, procedures etc)

    You could try to see if you find any clue in the sql default traces which should be there in the default error log folder. Do you have auditing by any chance?


    Regards, Ashwin Menon My Blog - http:\\sqllearnings.com

    • Marked as answer by tracycai Tuesday, July 29, 2014 9:51 AM
    Friday, July 25, 2014 12:23 PM

All replies

  • There might be manual change or may some other automated tasks might be involved, like agent jobs SP's triggers, application end codes etc..

    Raju Rasagounder Sr MSSQL DBA

    • Marked as answer by tracycai Tuesday, July 29, 2014 9:52 AM
    Friday, July 25, 2014 11:06 AM
  • The permissions wont get automatically changed by any means. There should be a user intervention either manually or through some code (job, procedures etc)

    You could try to see if you find any clue in the sql default traces which should be there in the default error log folder. Do you have auditing by any chance?


    Regards, Ashwin Menon My Blog - http:\\sqllearnings.com

    • Marked as answer by tracycai Tuesday, July 29, 2014 9:51 AM
    Friday, July 25, 2014 12:23 PM