SYS.CDBVIEW dependencies on CDBVIEW

Line 1: package body CDBView is

1: package body CDBView is
2:
3: type tabs_array is varray(11) of dbms_id;
4: sens_table_array tabs_array;
5: type sens_tabs is table of boolean index by dbms_id;

Line 13: -- newview_name before create_cdbview is invoked since all three are used

9: newview IN varchar2) return boolean;
10: -- Create the cdb view
11: -- private helper procedure to create the cdb view
12: -- Note that quotes should not be added around owner, oldview_name and
13: -- newview_name before create_cdbview is invoked since all three are used
14: -- as literals to query dictionary views.
15: procedure create_cdbview(chk_upgrd IN boolean, owner IN varchar2,
16: oldview_name IN varchar2, newview_name IN varchar2) as
17: sqlstmt varchar2(4000);

Line 15: procedure create_cdbview(chk_upgrd IN boolean, owner IN varchar2,

11: -- private helper procedure to create the cdb view
12: -- Note that quotes should not be added around owner, oldview_name and
13: -- newview_name before create_cdbview is invoked since all three are used
14: -- as literals to query dictionary views.
15: procedure create_cdbview(chk_upgrd IN boolean, owner IN varchar2,
16: oldview_name IN varchar2, newview_name IN varchar2) as
17: sqlstmt varchar2(4000);
18: col_name varchar2(128);
19: comments varchar2(4000);

Line 115: -- dbms_assert because catcdbviews.sql is called before dbms_assert

111: close colcommentscur;
112: end;
113:
114: -- This function is created to prevent SQL injection. We couldn't use
115: -- dbms_assert because catcdbviews.sql is called before dbms_assert
116: -- is created
117: function isLegalOwnerViewName(owner IN varchar2, oldview IN varchar2,
118: newview IN varchar2) return boolean as
119: cCheck number;

Line 171: -- not be allowed to be shadow-copied even within Create_CDBView.

167: end isLegalOwnerViewName;
168:
169: --
170: -- Initialize the list of SYS owned sensitive tables which should
171: -- not be allowed to be shadow-copied even within Create_CDBView.
172: --
173: -- Once ER 24598663 gets implemented, these entries will be part of a
174: -- SYS owned metadata table and instead of hard-coding the list, we will
175: -- be populating the list by fetching it from the table.

Line 187: end CDBView;

183: for i in 1..11 loop
184: sens_table_list(sens_table_array(i)) := TRUE;
185: end loop;
186:
187: end CDBView;