Home » Databases » HOWTO: SAP Sybase IQ: Grant bulk copy to a user (bulk read from a client file)

HOWTO: SAP Sybase IQ: Grant bulk copy to a user (bulk read from a client file)

We need to grant permission for the user to use readclientfile and we need to turn that option on if the application doesn’t do it itself.

grant readclientfile to testuser;
set option testuser.allow_read_client_file=on;
commit;

Oddly enough we can grant readclientfile to a group and turn on the option to a group but IQ will silently ignore the group option.

This works:

grant readclientfile to testgroup;
set option testuser.allow_read_client_file=on;
commit;

This doesn’t work:

grant readclientfile to testgroup;
set option testgroup.allow_read_client_file=on;
commit;

Verify that the user has the allow_read_client_file option:

SELECT 'SET ' + user_name + '.' + "option" + ' = ''' + setting + ''';'
FROM sys.sysoptions
WHERE "option" = 'allow_read_client_file'
  AND user_name = 'testuser'
Sybase

Sybase

Share Button

Leave a Reply

Your email address will not be published. Required fields are marked *

*
*

Facebook login by WP-FB-AutoConnect