Controls whether the read-write file operations of the database are restricted to the directory where the main database file is located and any subdirectories of this directory.
On, Off
Off
PUBLIC role | For current user | For other users | |
---|---|---|---|
Allowed to set permanently? | Yes, with SET ANY SECURITY OPTION | No | No |
Allowed to set temporarily? | Yes, with SET ANY SECURITY OPTION | No | No |
Setting this option to On restricts the read-write file operations on the database to the directory where the main database file is located and any subdirectories of this directory. The setting persists across sessions.