DBA Data[Home] [Help]

SYS.DBMS_JAVA_DEV dependencies on DBMS_ASSERT

Line 25: pkg_name := dbms_assert.simple_sql_name(jdev_grants(i));

21: and referenced_name in ('DBMS_JAVA','DBMS_JAVA_TEST','SQLJUTL',
22: 'SQLJUTL2','JVMRJBCINV','DBMS_JAVA_MISC');
23:
24: for i in 1..jdev_grants.count loop
25: pkg_name := dbms_assert.simple_sql_name(jdev_grants(i));
26: grantee := dbms_assert.enquote_name(jdev_grantees(i),FALSE);
27: stmt := 'grant execute on sys.' || pkg_name || ' to ' || grantee;
28: execute immediate stmt;
29: end loop;

Line 26: grantee := dbms_assert.enquote_name(jdev_grantees(i),FALSE);

22: 'SQLJUTL2','JVMRJBCINV','DBMS_JAVA_MISC');
23:
24: for i in 1..jdev_grants.count loop
25: pkg_name := dbms_assert.simple_sql_name(jdev_grants(i));
26: grantee := dbms_assert.enquote_name(jdev_grantees(i),FALSE);
27: stmt := 'grant execute on sys.' || pkg_name || ' to ' || grantee;
28: execute immediate stmt;
29: end loop;
30: