Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MySysTables objects what permissions?

Status
Not open for further replies.

millrat

Technical User
Dec 23, 2003
98
US
Hi,

What permissions to set up for a read only user to allow access to this.
millrat
 
millrat

Do you mean MSysObjects????? NONE. It is an internal table for M$-Access. And so are the rest of MSys..... tables. Read-only Users shouldn't mess with them.
 
I agree with JerryKlmns ... but if you must set priv's on System tables go to Tools, Options, View and check System Objects so that these MSys... tables are visible.

Then use Tools, Security, User and Group Permissions to set privs on them in the usual way. Your MSys tables will then be visible in the list of objects you an set priv's on. Just do so with caution.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top