View Full Version : Permission on msysobjects


susanjoseph
11-13-2001, 03:35 AM
Hi
I would like to read the contents of the
msysobject table through VB.The code used is
Set rs = db.Execute("select count(*) from msysobjects where type=1 and name like 'rt*' with owneraccess option")
But an error message saying "No read permission on 'msysobjects' pops up.

Could you help me on this.

Thanks
Susan

Pat Hartman
11-13-2001, 05:18 PM
Log in to the database with a userID that has admin rights and give yourself read permissions to the MSys tables.