Since the NIS XML was imported into the geodatabase, you need to assign permissions in the new NIS workspace to the editor and viewer database roles and assign the roles to the individual users.
In SQL Server Management Studio, grant permissions to the NIS workspace tables through database roles.
The sample script shows how to remove existing members from a role and drop the roles, re-create the roles, and assign permissions to the role through the schema.
set echo off;
set verify off;
set heading off;
set feedback off;
set newpage none;
set termout off;
set lines 200;
set trims on;
ttitle off;
btitle off;
clear;
SET SERVEROUTPUT ON;
spool Roles_nis.sql;
select 'DROP ROLE "RLNISEDITOR";' from dual;
select 'CREATE ROLE "RLNISEDITOR" NOT IDENTIFIED;' from dual;
select 'DROP ROLE "RLNISVIEWER";' from dual;
select 'CREATE ROLE "RLNISVIEWER" NOT IDENTIFIED;' from dual;
select 'grant select on ' ||owner|| '.' || table_name || ' to RLNISVIEWER;'
from sys.dba_tables where lower(owner) = 'nis' order by table_name;
select 'grant select,insert,update,delete on ' ||owner|| '.' || table_name || ' to RLNISEDITOR;'
from sys.dba_tables where lower(owner) = 'nis' order by table_name;
spool off;
set echo off;
set verify off;
set heading off;
set feedback off;
set newpage none;
set termout off;
set lines 200;
set trims on;
ttitle off;
btitle off;
clear;
SET SERVEROUTPUT ON;
/
@Roles_nis.sql;
/