|
Oracle 6.2.6 to 7.2.2, CreateOracleViews.SQL question
Posted: 08 Sep 08 12:45 PM
|
In the CreateoraclesViews.SQL it create a new view SLX_TABLE_VIEW using SYS instead of SYSDBA. Is there any reason the view is not created using SYSDBA (As the one right below in the snippet) and could their Oracle DBA create the view under SYSDBA instead? Does anyone know why this view is created using SYS?
/**********************************************************************************/
/* NEW IN SALESLOGIX v7.0 */
/**********************************************************************************/
create or replace view SYS.SLX_TABLE_VIEW as
select
U.NAME TABLE_SCHEMA,
O.NAME TABLE_NAME,
decode(O.TYPE#, 2, 'TABLE', 4, 'VIEW') TABLE_TYPE
from
SYS.OBJ$ o, SYS.USER$ u
where
(O.OWNER# = U.USER# and O.TYPE# in (2,4)) with read only;
-- grant permission for sysdba user
GRANT SELECT ON SLX_TABLE_VIEW TO "SYSDBA";
/***************************************************************************************/
/* NEW IN SALESLOGIX v6.1 */
/***************************************************************************************/
create or replace view sysdba.SLX_PLUGINNOBLOB as
select PLUGINID, NAME, FAMILY, TYPE, USERID, CREATEDATE, MODIFYDATE, LOCKED, LOCKEDID, VERSION, SYSTEM, ISPUBLIC, DESCRIPTION, DATACODE, BASEDON, TEMPLATE, AUTHOR, COMPANY, COMPANYVERSION, BASEDONCOMPANY, BASEDONCOMPANYVERSION, RELEASED, DEV, READONLY, INSTALLATIONDATE, RELEASEDDATE
from SYSDBA.PLUGIN;
create or replace view sysdba.SLX_RELEASEDPLUGINS as
select PLUGIN.USERID, SECCODE.SECCODEDESC, PLUGIN.BASEDON
from SYSDBA.PLUGIN, SYSDBA.SECCODE
where PLUGIN.USERID = SECCODE.SECCODEID; |
|
|