165: GLOBALPRIV8 number default 1,
166: GLOBALPRIV9 number default 1) is
167: cnt number(2);
168: begin
169: select count(*) into cnt from UMX_LSA_ROLE_GLOBAL_PRIVS where admin_role = adminRole;
170: if(cnt=0) then
171: insert into UMX_LSA_ROLE_GLOBAL_PRIVS(admin_role,
172: can_Create,
173: GLOBAL_PRIV2 ,
167: cnt number(2);
168: begin
169: select count(*) into cnt from UMX_LSA_ROLE_GLOBAL_PRIVS where admin_role = adminRole;
170: if(cnt=0) then
171: insert into UMX_LSA_ROLE_GLOBAL_PRIVS(admin_role,
172: can_Create,
173: GLOBAL_PRIV2 ,
174: GLOBAL_PRIV3 ,
175: GLOBAL_PRIV4 ,
188: GLOBALPRIV7 ,
189: GLOBALPRIV8 ,
190: GLOBALPRIV9 );
191: else
192: update UMX_LSA_ROLE_GLOBAL_PRIVS set can_Create = canCreate,
193: GLOBAL_PRIV2 = GLOBALPRIV2,
194: GLOBAL_PRIV3 = GLOBALPRIV3,
195: GLOBAL_PRIV4 = GLOBALPRIV4,
196: GLOBAL_PRIV5 = GLOBALPRIV5,