Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Somehow the business unit managed to change a regular table into a system table. Now nobody can read it or edit it. Engine is the owner and nobody has administer permissions. I noticed in MSysObjects that the flag for the table is -2147483648. The only other tables that have that flag are system tables. I feel like I need to change that to 0 and that might solve the problem too.

I tried doing like a GRANT SELECT in VBA but it didn't allow me to do that on the table. Not really sure where to go with this.

Any suggestions? Let me know if you need more details.

share|improve this question
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.