SELECT permission denied on object sysobjects

Question

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 739542 More actions · Answer 1

Do they get this when EM starts? Perhaps they do not have master access?

Dave Sundell SSChasing Mays Points: 653 More actions · Answer 2

The problem was that the 2 "deny" database roles were check. They were overiding the access.

Thanks.

Case closed.

MVDBA (Mike Vessey) SSC-Insane Points: 21797 More actions · Answer 3

you checked all the database roles?

including DENY_DATA_READER and DENY_DATA_WRITER

this sounds like the problem

you only need to grant them the single role of Database_owner and they have all the permissions you need.

remove all the others and you're laughing!

MVDBA