locked
Access denied though db read permissions provided for account RRS feed

  • Question

  • I have this service account that though db read permissions provided gets denied access on the database but other accounts work fine.
    Wednesday, December 16, 2009 6:18 PM

Answers

  • Thanks Ramakrishna.

    Finally figured out the issue. this role was part of a group for which the deny access was called for specific objects. Since we're trying to access those objects, it was denying access.

    • Marked as answer by Vish_Basha Wednesday, December 16, 2009 8:33 PM
    Wednesday, December 16, 2009 8:33 PM

All replies

  • Well, please can anyone help. What could be the issue?

    Wednesday, December 16, 2009 6:19 PM
  • Hi Vish,

    Could you provide with the exact error message ?


    Regards,
    Ramakrishna
    Wednesday, December 16, 2009 6:48 PM
  • Hi  Vish,


    The simple thing could be  you ( user with which you are accessing) don't have permission on that particular DB.

    try accessing  with SA and grant access.


    regards,
    Ramakrishna

    Wednesday, December 16, 2009 6:57 PM
  • Thanks Ramakrishna.

    Finally figured out the issue. this role was part of a group for which the deny access was called for specific objects. Since we're trying to access those objects, it was denying access.

    • Marked as answer by Vish_Basha Wednesday, December 16, 2009 8:33 PM
    Wednesday, December 16, 2009 8:33 PM