Configuring access permissions for Excel data in a workgroup when using the ODBC wrapper

You can configure your access permissions to access remote Excel data that is shared through a Windows network that uses workgroups.

1. Set the sharing and security model in the Network access: Sharing and security model for local accounts panel.
   You can select one of the following sharing and security models:

   Guest only – local users authenticate as Guest

   You connect to the data source through only the Guest user account. You receive the level of access that you configure for the Guest user account and must use your Db2® user password.

   Classic – local users authenticate as themselves

   You can use your Db2 user ID and password to connect to the data source or you can use the Guest user account. For the Db2 user ID, you receive the level of access to the data source according to the level of access of your Db2 user ID. For the Guest user account, you receive the level of access that you configure for the Guest user account and must use your Db2 user password.

   Example

   To select the Classic – local users authenticate as themselves sharing and security model, you open the Administrative Tools and navigate to Local Security Policy > Local policies > Security options > Network access: Sharing and security model for local accounts.

2. Create the user account in the Access this computer from the network Properties panel:

   Option	Description
   For the Guest only – local users authenticate as Guest security model	Specify the Windows workgroup and create the Guest user account. You must specify the password using your Db2 password.
   For the Classic – local users authenticate as themselves security model	Specify the Windows workgroup and create the user account using your Db2 user ID and password. If you want to use the Guest user account, specify the Windows workgroup and create the Guest user account. You must specify the password for the Guest user account using your Db2 password.

   Example

   To create the Guest user account:

   1. Open the Administrative Tools and navigate to Local Security Policy > Local policies > User Rights Assignment > Access the computer from network
   2. Specify the Windows workgroup in the From this location field.
   3. Specify the Db2 user ID in the Enter the object names to select field.
   4. Click Check Names.
   5. In the Enter Network Password panel, specify the Db2 user ID and password.

3. Set the share permissions in the Share Properties panel by setting the Change and Read permissions to Allow.

   Example

   To set the share permissions of the E:\share\test.xls network directory:

   • Right click the E:\share directory folder and then click Sharing and Security.
   • On the Sharing tab, select Share this folder and click Permissions.
   • Select the user and then select Allow for both the Change and Read permissions.

4. Set the NTFS permissions in the Properties panel by setting the Read & Execute and Read permissions to Allow.

   Example

   To set the NTFS permissions of the E:\share\test.xls file:

   • Right click the test.xls file and then click Properties.
   • On Security tab, select the user and then select Allow for both the Read & Execute and Read permissions.