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 OWNERSCCESS 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 2000 by Infinite Software Solutions, Inc.
Trademark Information
|