You use the CREATE SERVER statement or Create Directory Access Server Wizard in Sybase Central to create a directory access server.
When you create a directory access server, you can control the number of subdirectories that can be accessed and whether the directory access server can be used to modify existing files.
The following steps are required to set up a directory access server:
Create a remote server for the directory (requires DBA authority).
Create external logins for the database users who can use the directory access server (requires DBA authority).
Create proxy tables to access the directories on the computer (requires RESOURCE authority).
Use the SQL Anywhere 12 plug-in to connect to the host database as a user with DBA authority.
In the left pane, double-click Directory Access Servers.
Click File » New » Directory Access Server.
Follow the instructions in the Create Directory Access Server Wizard.
Connect to the host database as a user with DBA authority.
Create a remote server using the CREATE SERVER statement.
For example:
CREATE SERVER my_dir_tree CLASS 'directory' USING 'root=c:\Program Files'; |
Create an external login using the CREATE EXTERNLOGIN statement.
For example:
CREATE EXTERNLOGIN DBA TO my_dir_tree; |
Create a proxy table for the directory using the CREATE EXISTING TABLE statement.
For example:
CREATE EXISTING TABLE my_program_files AT 'my_dir_tree;;;.'; |
In this example, my_program_files is the name of the directory, and my_dir_tree is the name of the directory access server.
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |