Granting Authority to a Maintenance User ID

Grant DBA and RESOURCE authority if you are starting with a simple setup or are testing replication to Sybase IQ.

1. Use the Sybase IQ rssetup.sql sample script to create the maintenance user for Sybase IQ with relevant privileges.
   Warning!  If there is already a maintenance user ID, the script resets the password to the default password.

   grant connect to dbmaint identified by dbmaint
   grant DBA to dbmaint
   grant membership in group rs_systabgroup to dbmaint
   
   -- Create a user for REPSRV to extract -- materialization data, etc.
   -- Give sa user access to any replicated tables
   -- Give sa user access to REPSRV schema
   grant connect to sa identified by sysadmin
   grant DBA to sa
   grant membership in group rs_systabgroup to sa
   
   -- Allow sa and dbmaint to reference replicated tables created by DBA
   grant group to DBA
   grant membership in group DBA to dbmaint
   grant membership in group DBA to sa
   go

   This script is in the scripts directory within the Sybase IQ installation directory. For example, on UNIX platforms in:

   • Sybase IQ versions earlier than 15.0 – /$ASDIR/scripts

   • Sybase IQ 15.0 and later – /$IQDIR15/scripts

   See the Sybase IQ Installation and Configuration Guide for locations of directories.

2. Verify that the Sybase IQ database is compatible with Transact-SQL® (For IQ DBA).

   See Sybase IQ Reference: Statements and Options > Database Options > Transact-SQL Compatibility Options and Sybase IQ Reference: Building Blocks, Tables, and Procedures > Compatibility with Other Sybase Databases.

3. Grant the appropriate permissions to all tables and stored procedures that are to participate in replication.