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


Copyright 1999-2001 by Infinite Software Solutions, Inc. All rights reserved.
Trademark Information