SYS.CDBVIEW dependencies on USER$

Line 33: from sys.obj$ o, sys.user$ u, sys.com$ c

29: PRAGMA exception_init(insuff_privilege, -1031);
30:
31:
32: cursor tblcommentscur is select c.comment$
33: from sys.obj$ o, sys.user$ u, sys.com$ c
34: where o.name = upper_oldview and u.name = upper_owner
35: and o.obj# = c.obj# and o.owner#=u.user# and o.type# = 4
36: and c.col# is null;
37:

Line 39: from sys.obj$ o, sys.col$ c, sys.user$ u, sys.com$ co

35: and o.obj# = c.obj# and o.owner#=u.user# and o.type# = 4
36: and c.col# is null;
37:
38: cursor colcommentscur is select c.name, co.comment$, c.type#
39: from sys.obj$ o, sys.col$ c, sys.user$ u, sys.com$ co
40: where o.name = upper_oldview and u.name = upper_owner
41: and o.owner# = u.user# and o.type# = 4 and o.obj# = c.obj#
42: and c.obj# = co.obj# and c.intcol# = co.col#
43: and bitand(c.property, 32) = 0;

Line 56: -- Bug 27445727 : Certain SYS owned tables like USER$, LINK$ etc. are out

52: upper_owner := upper(owner);
53: upper_oldview := upper(oldview_name);
54:
55: --
56: -- Bug 27445727 : Certain SYS owned tables like USER$, LINK$ etc. are out
57: -- of bounds even for DBA level users. So we should not allow cloning such
58: -- tables into a Container_Data view and be able to bypass this protection.
59: --
60: -- Since this procedure does not support quoted identifiers, we need not

Line 126: -- USER$ contains both users and roles, exclude roles from the check

122: cleanNewview varchar2(128);
123: begin
124:
125: -- Check if owner already exist
126: -- USER$ contains both users and roles, exclude roles from the check
127: begin
128: execute immediate 'SELECT USER# FROM USER$ WHERE TYPE# = 1 AND NAME = :1'
129: into ownerId using upper(owner);
130: exception

Line 128: execute immediate 'SELECT USER# FROM USER$ WHERE TYPE# = 1 AND NAME = :1'

124:
125: -- Check if owner already exist
126: -- USER$ contains both users and roles, exclude roles from the check
127: begin
128: execute immediate 'SELECT USER# FROM USER$ WHERE TYPE# = 1 AND NAME = :1'
129: into ownerId using upper(owner);
130: exception
131: when no_data_found then return false;
132: end;

Line 178: sens_table_array := tabs_array('ENC$', 'LINK$', 'USER$', 'DEFAULT_PWD$',

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.
176: --
177: begin
178: sens_table_array := tabs_array('ENC$', 'LINK$', 'USER$', 'DEFAULT_PWD$',
179: 'XS$VERIFIERS', 'USER_HISTORY$',
180: 'HIST_HEAD$', 'HISTGRM$','CDB_LOCAL_ADMINAUTH$',
181: 'PDB_CREATE$','PDB_SYNC$');
182: