All Functions
WHERE Clause
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