JetSQL » Declarations » WITH OWNERACCESS OPTION
- Syntax:
- 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.
Examples
Code:
SELECT * FROM AtomicBombPlans
WITH OWNERACCESS OPTION Explanation:
Note that this declaration is placed at the end of the SQL query.
Language(s): MS SQL Server
See Also:
