I have an issue with 2 users who have access to all the db's but two of those db's they get an error when accessing objects
i have doubled check their permission it has no deny db reader or writer all are db_owner, when i grant them sysadmin as a test it works. Any idea
It's better to fail while trying, rather than fail without trying!!!