DevGuru Jet SQL WITH OWNERACCESS OPTION Declaration

Quick References

Features

Partners


			DECLARATION: WITH OWNERACCESS OPTION sqlstatement WITH OWNERACCESS OPTION The WITH OWNERACCESS OPTION is a very specialized declaration which is designed to be used in a secure multiuser environment. Normally, in such an environment, only members of the designated working group, who log on with user names and passwords, have access to the database. However, the optional WITH OWNERACCESS OPTION declaration allows non-members to have permission to access the secure database (i.e., the user who submits the query has the same permissions as the query's owner) This declaration requires access to the database System.mdw file. Note that this declaration is placed at the end of the SQL query: SELECT * FROM AtomicBombPlans WITH OWNERACCESS OPTION