DCSIMG
Record(s) cannot be read; no read permission on 'MSYSObjects' - SQL SERVER DBAces And More

SQL SERVER DBAces And More

שרון כהן שכן טוב

Record(s) cannot be read; no read permission on 'MSYSObjects'

Problem: I tried to load a system table from Microsoft Access from a C# application and got the error message "Record(s) cannot be read; no read permission on 'MSYSObjects'".

 Solution: To add permission to the systable:

 1) Tools -> Options, on the view tab check 'system object'.

2) Tools -> Security -> User and group permissions, on each of the new tables give it 'administrator' access .

 

Have a nice day. Sharon

Posted: Dec 07 2009, 11:17 AM by DBASharon | with 2 comment(s)
תגים:

Comments

Vibhore said:

Thank you very much the above steps helped me to resolve the issue.

# February 2, 2010 3:22 PM

ved.soni@rediffmail.com said:

but in particular table the owner is <unknown> and when i want to change owner a error arise

# March 23, 2010 9:35 AM
Leave a Comment

(required) 

(required) 

(optional)

(required) 


Enter the numbers above: