none
Lost Access to all items inn SCCM/SQL ? RRS feed

  • שאלה

  • Hello,

    As I lost access to all items inside the SCCM Collection I am suspecting a database/table security change. How could I detect it in SQL if any? I check the SQL Server Log, nothing in it... How to check the permissions on specific tables?

    I checked with several other accounts and it is the same issue, no access except "Read"

    How to change any permissions as I read some article saying the Database/Table was suddenly passed in Read Mode !! ? should I have a trace of this somewhere?

    SQL Server 2016

    SCCM 1610

    My account is set in:

    SQL Role: sysadmin, membership nothing checked, Default Schema: dbo

    Local Administrators

    SMSAdmins

    Thanks,

    Dom


    Security / System Center Operations Manager 2012 / System Center Configuration Manager 2012 / SQL System Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 / Forefront Client Security / Forefront Identity Manager


    • נערך על-ידי Felyjos יום חמישי 27 יולי 2017 14:57
    יום חמישי 27 יולי 2017 14:55

תשובות

  • Licensing issues...

    fixed after applying a new license

    Thanks,
    Dom


    Security / System Center Operations Manager 2012 / System Center Configuration Manager 2012 / SQL System Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 / Forefront Client Security / Forefront Identity Manager

    • סומן כתשובה על-ידי Felyjos יום חמישי 27 יולי 2017 17:15
    יום חמישי 27 יולי 2017 17:15