/*#ifndef RSSETUP_SQL_HEADER
**#define RSSETUP_SQL_HEADER
**static char SCCS_ID[] = @(#) LIV  2001/08/01 11:27:34   rssetup.sql \main\callpilot2.0\1 ~
** LIV  2001/08/01 11:27:34   rssetup.sql \main\callpilot2.0\1 ~
** [liv/Database/nbdb0078]
**
**#endif
*/
-- Create a user for REPSRV to execute DML
-- Give dbmaint user access to any replicated tables
-- Give dbmaint user access to REPSRV schema
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