﻿* SET_DB_M.TXT HARASAWA (MSSQL)
=IF{_DB!='M'}JUMP{M_SKIP};
=LOGIN_SQL{EXEC SP_CONFIGURE 'SHOW ADVANCED OPTIONS','1'};
=LOGIN_SQL{RECONFIGURE WITH OVERRIDE};
=LOGIN_SQL{EXEC SP_CONFIGURE 'REMOTE LOGIN TIMEOUT',60};
=LOGIN_SQL{EXEC SP_CONFIGURE 'REMOTE QUERY TIMEOUT',0};
=LOGIN_SQL{RECONFIGURE WITH OVERRIDE};
***********************( CREATE DATABASE )*******************
*(PERMISSION_BEGIN)*
=IF{_DB!='M'}JUMP{M_SKIP};
REPEAT0=$W0PERMISSION
REPEAT=4 (W_D##,W_L##,W_BDAT##,W_BLOG##)
=MESSAGE{CREATE DATABASE (?W_PER$$?)}; 
=SET{W_DB='?W_IS??W_##?_?W_PER$$?'};
=LOGIN_SQL{CREATE DATABASE ?W_DB? ON PRIMARY(
=NAME=DAT
=,FILENAME='?W_D##??_P??W_DB?_DAT.MDF'
=,FILEGROWTH=1) LOG ON(NAME=LOG
=,FILENAME='?W_L##??_P??W_DB?_LOG.LDF'
=,FILEGROWTH=1)}IF{_DB_ERROR!='M1801'}ERROR{};
=LOGIN_SQL{EXEC SP_ADDUMPDEVICE 'DISK','?W_DB?_DAT'
=,'?W_BDAT##??_P??W_DB?.DAT'}
=  IF{_DB_ERROR!='M15026'}ERROR{?_DB_ERROR? ?_ERROR?};
=LOGIN_SQL{EXEC SP_ADDUMPDEVICE 'DISK','?W_DB?_LOG'
=,'?W_BLOG##??_P??W_DB?.LOG'}
=  IF{_DB_ERROR!='M15026'}IF{_DB_ERROR!='M15061'}ERROR{};
=IF{_DB_SOFT/'M200'}JUMP{OLD};
=SET{W_EX_DB='ALTER DATABASE ?W_DB? SET'};
=LOGIN_SQL{?W_EX_DB? AUTO_CLOSE OFF};
=LOGIN_SQL{?W_EX_DB? AUTO_SHRINK ON};
1+=LOGIN_SQL{?W_EX_DB? RECOVERY FULL};
1-=LOGIN_SQL{?W_EX_DB? RECOVERY SIMPLE};
*2-4-=LOGIN_SQL{?W_EX_DB?,'SELECT INTO/BULKCOPY','FALSE'};
*1-3-=LOGIN_SQL{?W_EX_DB?,'SELECT INTO/BULKCOPY','TRUE'};
=JUMP{J};
=OLD:
=SET{W_EX_DB='EXEC SP_DBOPTION ''?W_DB?'''};
=LOGIN_SQL{?W_EX_DB?,'AUTOCLOSE','FALSE'};
=LOGIN_SQL{?W_EX_DB?,'AUTOSHRINK','TRUE'};
1+=LOGIN_SQL{?W_EX_DB?,'TRUNC. LOG ON CHKPT.','FALSE'};
1-=LOGIN_SQL{?W_EX_DB?,'TRUNC. LOG ON CHKPT.','TRUE'};
2-4-=LOGIN_SQL{?W_EX_DB?,'SELECT INTO/BULKCOPY','FALSE'};
1-3-=LOGIN_SQL{?W_EX_DB?,'SELECT INTO/BULKCOPY','TRUE'};
=J:
REPEAT0=
***********************( EXEC SP_ADDLOGIN )******************
REPEAT0=$W0PERMISSION
REPEAT=2 (W_R_T##)
=SET{WPAS=W_PASSWORD_?W_REAL_TEST##?};
=SET{W0REPEAT2CNT=0};
REPEAT2=4 (W_DIOL--)
=COMPUTE{W0REPEAT2CNT+=1};
=MESSAGE{EXEC SP_ADDLOGIN (?W_REAL_TEST##?,?W_PER$$?)}; 
=SET{W_DIOL=W_DIOL?W0REPEAT2CNT?};
=SET{W_USER=''};
=IF{W0REPEAT2CNT=4}SET{WPAS=W_PASSWORD_LINK};
=LOGIN_SQL{EXEC SP_ADDLOGIN
=          '?W_IS??W_R_T##?_?W_DIOL?_?W_PER$$?'
=,'?WPAS?','?W_IS??W_R_T##?_M_?W_PER$$?'}
=  IF{_DB_ERROR!='M15025'}ERROR{};
REPEAT0=
******************( CREATE USER )****************************
REPEAT0=$W0PERMISSION
REPEAT=3 (W_RTT##;W_RRT##)
=SET{W0REPEAT2CNT=0};
REPEAT2=$W0PERMISSION   (W_PER(ALL)) 
=COMPUTE{W0REPEAT2CNT+=1};
=SET{W_PER_ALL=W_PER?W0REPEAT2CNT?};
=MESSAGE{EXEC CREATE USER (?W_PER$$?)}; 
=LOGIN_SQL{USE ?W_IS??W_RTT##?_M_?W_PER_ALL?
=  CREATE USER ?W_IS??W_RRT##?_D_?W_PER$$?
=  WITH DEFAULT_SCHEMA=DBO}
=  IF{_DB_ERROR!='M15023'}ERROR{};
=LOGIN_SQL{USE ?W_IS??W_RTT##?_W_?W_PER_ALL?
=  CREATE USER ?W_IS??W_RRT##?_D_?W_PER$$?
=  WITH DEFAULT_SCHEMA=DBO}
=  IF{_DB_ERROR!='M15023'}ERROR{};
=LOGIN_SQL{USE ?W_IS??W_RTT##?_M_?W_PER_ALL?
=  CREATE USER ?W_IS??W_RRT##?_I_?W_PER$$?
=  WITH DEFAULT_SCHEMA=DBO}
=IF{_DB_ERROR!='M15023'}ERROR{};
=LOGIN_SQL{USE ?W_IS??W_RTT##?_W_?W_PER_ALL?
=  CREATE USER ?W_IS??W_RRT##?_I_?W_PER$$?
=  WITH DEFAULT_SCHEMA=DBO}
=IF{_DB_ERROR!='M15023'}ERROR{};
=LOGIN_SQL{USE ?W_IS??W_RTT##?_M_?W_PER_ALL?
=  CREATE USER ?W_IS??W_RRT##?_O_?W_PER$$?
=  WITH DEFAULT_SCHEMA=DBO}
=IF{_DB_ERROR!='M15023'}ERROR{};
=LOGIN_SQL{USE ?W_IS??W_RTT##?_W_?W_PER_ALL?
=  CREATE USER ?W_IS??W_RRT##?_O_?W_PER$$?
=  WITH DEFAULT_SCHEMA=DBO}
=IF{_DB_ERROR!='M15023'}ERROR{};
=LOGIN_SQL{USE ?W_IS??W_RTT##?_M_?W_PER_ALL?
=  CREATE USER ?W_IS??W_RRT##?_L_?W_PER$$?
=  WITH DEFAULT_SCHEMA=DBO}
=IF{_DB_ERROR!='M15023'}ERROR{};
=LOGIN_SQL{USE ?W_IS??W_RTT##?_W_?W_PER_ALL?
=  CREATE USER ?W_IS??W_RRT##?_L_?W_PER$$?
=  WITH DEFAULT_SCHEMA=DBO}
=IF{_DB_ERROR!='M15023'}ERROR{};
REPEAT0=
*****************( SP_ADDROLEMEMBER )************************
REPEAT0=$W0PERMISSION
=MESSAGE{EXEC EXEC SP_ADDROLEMEMBER (?W_PER$$?)}; 
REPEAT=3 (W_RTT##;W_RRT##)
=SET{W_PERX='ZZZZ'};
=SET{W0REPEAT2CNT=0};
REPEAT2=2 (W_PER--;(ZZZZ;自分))
=COMPUTE{W0REPEAT2CNT+=1}; 
=IF{W0REPEAT2CNT=2}SET{W_PERX=W_PER$$};
=LOGIN_SQL{USE ?W_IS??W_RTT##?_M_?W_PER$$? 
= EXEC SP_ADDROLEMEMBER 'DB_OWNER'
= ,'?W_IS?R_D_ZZZZ'};
=LOGIN_SQL{USE ?W_IS??W_RTT##?_M_?W_PER$$? 
= EXEC SP_ADDROLEMEMBER 'DB_OWNER'
= ,'?W_IS??W_RRT##?_D_?W_PERX?'};
=LOGIN_SQL{USE ?W_IS??W_RTT##?_W_?W_PER$$?
= EXEC SP_ADDROLEMEMBER 'DB_OWNER'
= ,'?W_IS??W_RRT##?_D_?W_PERX?'};
=LOGIN_SQL{USE ?W_IS??W_RTT##?_W_?W_PER$$?
= EXEC SP_ADDROLEMEMBER 'DB_OWNER'
= ,'?W_IS??W_RRT##?_I_?W_PERX?'};
=LOGIN_SQL{USE ?W_IS??W_RTT##?_W_?W_PER$$?
= EXEC SP_ADDROLEMEMBER 'DB_OWNER'
= ,'?W_IS??W_RRT##?_O_?W_PERX?'};
=IF{W_PER$$='ZZZZ'}JUMP{J};
REPEAT2=
=J:
REPEAT0=
=JUMP{M_SKIP};
*********( CREATE VIEW )***********************************
*****( OBJECT_VIEW )***************************************
NAME=M_OBJECT_VIEW
=SET{WI=W_INSERT+'''M'','};
COPY=ADD10
=SQL{?W?'(ZZZZZZ_KIND,ZZZZZZ_REAL,ZZZZZZ_WORK')};
COPY=ADD10
=SQL{?W?',ZZZZZZ_USER,ZZZZZZ_NAME,ZZZZZZ_TEXT')};
COPY=ADD10
=SQL{?W?',ZZZZZZ_ADD_DATE17,ZZZZZZ_CHANGE_DATE17)')};
COPY=ADD10
=SQL{?W?' AS SELECT CAST(CASE O.TYPE WHEN ''U''')};
COPY=ADD10
=SQL{?W?' THEN ''TABLE'' WHEN ''V'' THEN ''VIEW''')};
COPY=ADD10
=SQL{?W?' WHEN ''P'' THEN ''PROC''')};
COPY=ADD10
=SQL{?W?' WHEN ''FN'' THEN ''FUNC''')};
COPY=ADD10
=SQL{?W?' WHEN ''TR'' THEN ''TRIG'' ELSE ''XXXXX'' END')};
COPY=ADD10
=SQL{?W?' AS CHAR(5))')};
COPY=ADD10
=SQL{?W?',CAST(''?_Q?_REAL_TEST?_Q?'' AS CHAR(4))')};
COPY=ADD10
=SQL{?W?',CAST(''?W_MAST_WORK?'' AS CHAR(4))')};
COPY=ADD10
=SQL{?W?',CAST('' '' AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(O.NAME AS NCHAR(30))')};
COPY=ADD10
=SQL{?W?',C.DEFINITION,CAST(REPLACE(REPLACE(')};
COPY=ADD10
=SQL{?W?' REPLACE(REPLACE(CONVERT(CHAR(23)')};
COPY=ADD10
=SQL{?W?',O.CREATE_DATE,121),''-''')};
COPY=ADD10
=SQL{?W?',''''),'':'',''''),''.'',''''),'' '','''')')};
COPY=ADD10
=SQL{?W?' AS CHAR(17))')};
COPY=ADD10
=SQL{?W?',CAST(REPLACE(REPLACE(REPLACE(REPLACE(')};
COPY=ADD10
=SQL{?W?' CONVERT(CHAR(23),O.MODIFY_DATE,121),''-''')};
COPY=ADD10
=SQL{?W?',''''),'':'',''''),''.'',''''),'' '','''')')};
COPY=ADD10
=SQL{?W?' AS CHAR(17)) FROM')};
COPY=ADD10
=SQL{?W?' ?W_M_DB?.SYS.SCHEMAS S,')};
COPY=ADD10
=SQL{?W?' ?W_M_DB?.SYS.OBJECTS O')};
COPY=ADD10
=SQL{?W?' LEFT JOIN')};
COPY=ADD10
=SQL{?W?' ?W_M_DB?.SYS.SQL_MODULES C ')};
COPY=ADD10
=SQL{?W?' ON C.OBJECT_ID=O.OBJECT_ID ')};
COPY=ADD10
=SQL{?W?' WHERE S.SCHEMA_ID=O.SCHEMA_ID')};
COPY=ADD10
=SQL{?W?' AND S.NAME=''DBO''')};
COPY=ADD10
=SQL{?W?' AND O.TYPE IN(''U'',''V'',''P'',''TR'',''FN'')')};
COPY=ADD10
NAME=
***( COLUMN_VIEW )*******************************************
NAME=M_COLUMN_VIEW
=SET{WI=W_INSERT+'''M'','};
COPY=ADD10
=SQL{?W?'(ZZZZZZ_KIND,ZZZZZZ_REAL,ZZZZZZ_WORK')};
COPY=ADD10
=SQL{?W?',ZZZZZZ_USER,ZZZZZZ_NAME,ZZZZZZ_SEQ')};
COPY=ADD10
=SQL{?W?',ZZZZZZ_DATA_NAME,ZZZZZZ_DEFAULT_TYPE')};
COPY=ADD10
=SQL{?W?',ZZZZZZ_DEFAULT_LENGTH1')};
COPY=ADD10
=SQL{?W?',ZZZZZZ_DEFAULT_LENGTH2,ZZZZZZ_DEFAULT')};
COPY=ADD10
=SQL{?W?',ZZZZZZ_NULL)AS SELECT CAST(CASE O.TYPE')};
COPY=ADD10
=SQL{?W?' WHEN ''U'' THEN ''TABLE''')};
COPY=ADD10
=SQL{?W?' WHEN ''V'' THEN ''VIEW''')};
COPY=ADD10
=SQL{?W?' ELSE ''XXXXX'' END')};
COPY=ADD10
=SQL{?W?' AS CHAR(5))')};
COPY=ADD10
=SQL{?W?',CAST(''?_Q?_REAL_TEST?_Q?'' AS CHAR(4))')};
COPY=ADD10
=SQL{?W?',CAST(''?W_MAST_WORK?'' AS CHAR(4))')};
COPY=ADD10
=SQL{?W?',CAST('' '' AS CHAR(1)),CAST(O.NAME')};
COPY=ADD10
=SQL{?W?' AS NCHAR(30))')};
COPY=ADD10
=SQL{?W?',CAST(C.COLUMN_ID AS INT)')};
COPY=ADD10
=SQL{?W?',CAST(C.NAME AS NCHAR(30))')};
COPY=ADD10
=SQL{?W?',CAST(UPPER(T.NAME)AS CHAR(9))')};
COPY=ADD10
=SQL{?W?',CAST(CASE WHEN T.NAME IN(''BINARY''')};
COPY=ADD10
=SQL{?W?',''CHAR'',''VARCHAR'',''DECIMAL''')};
COPY=ADD10
=SQL{?W?',''NCHAR'',''NVARCHAR'',''DECIMAL''')};
COPY=ADD10
=SQL{?W?',''NUMERIC'') THEN CASE C.PRECISION')};
COPY=ADD10
=SQL{?W?' WHEN 0 THEN CASE WHEN C.MAX_LENGTH<=0')};
COPY=ADD10
=SQL{?W?' THEN 4000 ELSE CASE WHEN T.NAME')};
COPY=ADD10
=SQL{?W?' IN(''NCHAR'',''NVARCHAR'') THEN')};
COPY=ADD10
=SQL{?W?' C.MAX_LENGTH/2 ELSE C.MAX_LENGTH')};
COPY=ADD10
=SQL{?W?' END END ELSE C.PRECISION END')};
COPY=ADD10
=SQL{?W?' WHEN T.NAME=''DATETIME'' THEN 17')};
COPY=ADD10
=SQL{?W?' WHEN T.NAME=''DATE'' THEN 8')};
COPY=ADD10
=SQL{?W?' WHEN T.NAME=''TEXT'' THEN 4000')};
COPY=ADD10
=SQL{?W?' ELSE 9 END AS INT),CAST(CASE')};
COPY=ADD10
=SQL{?W?' WHEN T.NAME IN(''DECIMAL'',''NUMERIC'')')};
=COMPUTE{ W0+=100};SET{W=WI+W0+',?_N?'};
=SQL{?W?' THEN C.SCALE ELSE 0 END AS INT)')};
COPY=ADD10
=SQL{?W?',CAST(CASE WHEN D.DEFINITION')};
COPY=ADD10
=SQL{?W?' IS NULL THEN NULL WHEN')};
COPY=ADD10
=SQL{?W?' DATALENGTH(RTRIM(D.DEFINITION))<3 THEN ')};
COPY=ADD10
=SQL{?W?' D.DEFINITION ')};
COPY=ADD10
=SQL{?W?' ELSE SUBSTRING(D.DEFINITION,2')};
COPY=ADD10
=SQL{?W?',DATALENGTH(CONVERT(')};
COPY=ADD10
=SQL{?W?' VARCHAR,D.DEFINITION))-2) END')};
COPY=ADD10
=SQL{?W?' AS NCHAR(30))')};
COPY=ADD10
=SQL{?W?',CAST(CASE WHEN C.IS_NULLABLE=''1''')};
COPY=ADD10
=SQL{?W?' THEN ''1'' ELSE ''0'' END AS CHAR(1))')};
COPY=ADD10
=SQL{?W?' FROM')};
COPY=ADD10
=SQL{?W?' ?W_M_DB?.SYS.COLUMNS C JOIN')};
COPY=ADD10
=SQL{?W?' ?W_M_DB?.SYS.OBJECTS O')};
COPY=ADD10
=SQL{?W?' ON C.OBJECT_ID=O.OBJECT_ID AND O.TYPE')};
COPY=ADD10
=SQL{?W?' IN(''U'',''V'')JOIN')};
COPY=ADD10
=SQL{?W?' ?W_M_DB?.SYS.SCHEMAS S')};
COPY=ADD10
=SQL{?W?' ON S.SCHEMA_ID=O.SCHEMA_ID')};
COPY=ADD10
=SQL{?W?' AND S.NAME=''DBO'' JOIN')};
COPY=ADD10
=SQL{?W?' ?W_M_DB?.SYS.TYPES T')};
COPY=ADD10
=SQL{?W?' ON C.USER_TYPE_ID=T.USER_TYPE_ID ')};
COPY=ADD10
=SQL{?W?' AND C.SYSTEM_TYPE_ID=T.SYSTEM_TYPE_ID')};
COPY=ADD10
=SQL{?W?' LEFT JOIN')};
COPY=ADD10
=SQL{?W?' ?W_M_DB?.SYS')};
COPY=ADD10
=SQL{?W?'.DEFAULT_CONSTRAINTS')};
COPY=ADD10
=SQL{?W?' D ON D.OBJECT_ID=C.DEFAULT_OBJECT_ID')};
*****( INDEX_VIEW )******************************************
NAME=M_INDEX_VIEW
=SET{WI=W_INSERT+'''M'','};
COPY=ADD10
=SQL{?W?'(ZZZZZZ_REAL,ZZZZZZ_WORK,ZZZZZZ_USER')};
COPY=ADD10
=SQL{?W?',ZZZZZZ_NAME,ZZZZZZ_DATA_NAME,ZZZZZZ_IX')};
COPY=ADD10
=SQL{?W?',ZZZZZZ_NO)AS SELECT')};
COPY=ADD10
=SQL{?W?' CAST(''?_Q?_REAL_TEST?_Q?'' AS CHAR(4))')};
COPY=ADD10
=SQL{?W?',CAST(''?W_MAST_WORK?'' AS CHAR(4))')};
COPY=ADD10
=SQL{?W?',CAST('' '' AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(O.NAME AS NCHAR(30))')};
COPY=ADD10
=SQL{?W?',CAST(C.NAME AS NCHAR(30))')};
COPY=ADD10
=SQL{?W?',CAST(RIGHT(I.NAME,1) AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(K.KEY_ORDINAL-I.IS_UNIQUE AS INT)FROM')};
COPY=ADD10
=SQL{?W?' ?W_M_DB?.SYS.INDEXES I JOIN')};
COPY=ADD10
=SQL{?W?' ?W_M_DB?.SYS.INDEX_COLUMNS K')};
COPY=ADD10
=SQL{?W?' ON I.INDEX_ID=K.INDEX_ID')};
COPY=ADD10
=SQL{?W?' AND I.OBJECT_ID=K.OBJECT_ID JOIN')};
COPY=ADD10
=SQL{?W?' ?W_M_DB?.SYS.OBJECTS O')};
COPY=ADD10
=SQL{?W?' ON O.OBJECT_ID=I.OBJECT_ID  ')};
COPY=ADD10
=SQL{?W?' AND I.NAME IN(O.NAME+''0'',O.NAME+''1''')};
COPY=ADD10
=SQL{?W?',O.NAME+''2'',O.NAME+''3'',O.NAME+''4''')};
COPY=ADD10
=SQL{?W?',O.NAME+''5'',O.NAME+''6'',O.NAME+''7''')};
COPY=ADD10
=SQL{?W?',O.NAME+''8'',O.NAME+''9'')')};
COPY=ADD10
=SQL{?W?' AND O.TYPE IN(''U'',''V'') JOIN')};
COPY=ADD10
=SQL{?W?' ?W_M_DB?.SYS.COLUMNS C')};
COPY=ADD10
=SQL{?W?' ON C.OBJECT_ID=I.OBJECT_ID')};
COPY=ADD10
=SQL{?W?' AND C.COLUMN_ID=K.COLUMN_ID JOIN')};
COPY=ADD10
=SQL{?W?' ?W_M_DB?.SYS.SCHEMAS S')};
COPY=ADD10
=SQL{?W?' ON S.SCHEMA_ID=O.SCHEMA_ID')};
COPY=ADD10
=SQL{?W?' AND S.NAME=''DBO''')};
*****( GRANT_VIEW )******************************************
NAME=M_GRANT_VIEW
=SET{WI=W_INSERT+'''M'','};
COPY=ADD10
=SQL{?W?'(ZZZZZZ_KIND,ZZZZZZ_REAL,ZZZZZZ_WORK')};
COPY=ADD10
=SQL{?W?',ZZZZZZ_USER,ZZZZZZ_NAME,ZZZZZZ_GRANT')};
COPY=ADD10
=SQL{?W?',ZZZZZZ_SELECT,ZZZZZZ_INSERT')};
COPY=ADD10
=SQL{?W?',ZZZZZZ_UPDATE,ZZZZZZ_DELETE')};
COPY=ADD10
=SQL{?W?',ZZZZZZ_EXECUTE)AS SELECT CAST(CASE O.TYPE ')};
COPY=ADD10
=SQL{?W?' WHEN ''U'' THEN ''TABLE''')};
COPY=ADD10
=SQL{?W?' WHEN ''V'' THEN ''VIEW''')};
COPY=ADD10
=SQL{?W?' WHEN ''P'' THEN ''PROC''')};
COPY=ADD10
=SQL{?W?' WHEN ''FN'' THEN ''FUNC''')};
COPY=ADD10
=SQL{?W?' WHEN ''TR'' THEN ''TRIG''')};
COPY=ADD10
=SQL{?W?' ELSE ''XXXXX'' END AS CHAR(5))')};
COPY=ADD10
=SQL{?W?',CAST(''?_Q?_REAL_TEST?_Q?'' AS CHAR(4))')};
COPY=ADD10
=SQL{?W?',CAST(''?W_MAST_WORK?'' AS CHAR(4))')};
COPY=ADD10
=SQL{?W?',CAST('' '' AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(O.NAME AS NCHAR(30))')};
COPY=ADD10
=SQL{?W?',CAST(UPPER(RIGHT(U0.NAME,6)) AS CHAR(6))')};
COPY=ADD10
=SQL{?W?',CAST(CASE SUBSTRING(P0.TYPE,1,1)')};
COPY=ADD10
=SQL{?W?' WHEN ''S'' THEN ''S'' ')};
COPY=ADD10
=SQL{?W?' ELSE '' '' END AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(SUBSTRING(P1.TYPE,1,1) AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(SUBSTRING(P2.TYPE,1,1) AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(SUBSTRING(P3.TYPE,1,1) AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(CASE SUBSTRING(P0.TYPE,1,1)')};
COPY=ADD10
=SQL{?W?' WHEN ''E'' THEN ''E'' ')};
COPY=ADD10
=SQL{?W?' ELSE '' '' END AS CHAR(1)) FROM')};
COPY=ADD10
=SQL{?W?' ?W_M_DB?.SYS.OBJECTS O JOIN')};
COPY=ADD10
=SQL{?W?' ?W_M_DB?.SYS')};
COPY=ADD10
=SQL{?W?'.DATABASE_PERMISSIONS')};
COPY=ADD10
=SQL{?W?' P0 ON O.OBJECT_ID=P0.MAJOR_ID')};
COPY=ADD10
=SQL{?W?' AND (P0.TYPE=''SL'' ')};
COPY=ADD10
=SQL{?W?' AND O.TYPE IN(''U'',''V'')')};
COPY=ADD10
=SQL{?W?' OR P0.TYPE=''EX'' ')};
COPY=ADD10
=SQL{?W?' AND O.TYPE IN(''P'',''FN''))JOIN')};
COPY=ADD10
=SQL{?W?' ?W_M_DB?.SYS')};
COPY=ADD10
=SQL{?W?'.DATABASE_PRINCIPALS')};
COPY=ADD10
=SQL{?W?' U0 ON (U0.NAME LIKE ')};
COPY=ADD10
=SQL{?W?' ''?_Q?_DB_HEADER?_Q?%''')};
COPY=ADD10
=SQL{?W?' OR U0.NAME=LOWER(''PUBLIC''))')};
COPY=ADD10
=SQL{?W?' AND P0.GRANTEE_PRINCIPAL_ID')};
COPY=ADD10
=SQL{?W?'=U0.PRINCIPAL_ID LEFT JOIN')};
COPY=ADD10
=SQL{?W?' ?W_M_DB?.SYS')};
COPY=ADD10
=SQL{?W?'.DATABASE_PERMISSIONS')};
COPY=ADD10
=SQL{?W?' P1 ON O.OBJECT_ID=P1.MAJOR_ID AND')};
COPY=ADD10
=SQL{?W?' P0.GRANTOR_PRINCIPAL_ID')};
COPY=ADD10
=SQL{?W?'=P1.GRANTOR_PRINCIPAL_ID')};
COPY=ADD10
=SQL{?W?' AND P1.TYPE=''IN'' AND ')};
COPY=ADD10
=SQL{?W?' P0.GRANTEE_PRINCIPAL_ID')};
COPY=ADD10
=SQL{?W?'=P1.GRANTEE_PRINCIPAL_ID LEFT JOIN')};
COPY=ADD10
=SQL{?W?' ?W_M_DB?.SYS')};
COPY=ADD10
=SQL{?W?'.DATABASE_PRINCIPALS')};
COPY=ADD10
=SQL{?W?' U1 ON U0.NAME=U1.NAME ')};
COPY=ADD10
=SQL{?W?' AND P1.GRANTEE_PRINCIPAL_ID')};
COPY=ADD10
=SQL{?W?'=U1.PRINCIPAL_ID LEFT JOIN')};
COPY=ADD10
=SQL{?W?' ?W_M_DB?.SYS')};
COPY=ADD10
=SQL{?W?'.DATABASE_PERMISSIONS')};
COPY=ADD10
=SQL{?W?' P2 ON O.OBJECT_ID=P2.MAJOR_ID AND')};
COPY=ADD10
=SQL{?W?' P0.GRANTOR_PRINCIPAL_ID')};
COPY=ADD10
=SQL{?W?'=P2.GRANTOR_PRINCIPAL_ID')};
COPY=ADD10
=SQL{?W?' AND P2.TYPE=''UP'' AND ')};
COPY=ADD10
=SQL{?W?' P0.GRANTEE_PRINCIPAL_ID')};
COPY=ADD10
=SQL{?W?'=P2.GRANTEE_PRINCIPAL_ID LEFT JOIN')};
COPY=ADD10
=SQL{?W?' ?W_M_DB?.SYS')};
COPY=ADD10
=SQL{?W?'.DATABASE_PRINCIPALS')};
COPY=ADD10
=SQL{?W?' U2 ON U0.NAME=U2.NAME AND ')};
COPY=ADD10
=SQL{?W?' P2.GRANTEE_PRINCIPAL_ID')};
COPY=ADD10
=SQL{?W?'=U2.PRINCIPAL_ID LEFT JOIN ')};
COPY=ADD10
=SQL{?W?' ?W_M_DB?.SYS')};
COPY=ADD10
=SQL{?W?'.DATABASE_PERMISSIONS')};
COPY=ADD10
=SQL{?W?' P3 ON O.OBJECT_ID=P3.MAJOR_ID AND')};
COPY=ADD10
=SQL{?W?' P0.GRANTOR_PRINCIPAL_ID')};
COPY=ADD10
=SQL{?W?'=P3.GRANTOR_PRINCIPAL_ID')};
COPY=ADD10
=SQL{?W?' AND P3.TYPE=''DE'' AND')};
COPY=ADD10
=SQL{?W?' P0.GRANTEE_PRINCIPAL_ID')};
COPY=ADD10
=SQL{?W?'=P3.GRANTEE_PRINCIPAL_ID LEFT JOIN')};
COPY=ADD10
=SQL{?W?' ?W_M_DB?.SYS')};
COPY=ADD10
=SQL{?W?'.DATABASE_PRINCIPALS')};
COPY=ADD10
=SQL{?W?' U3 ON U0.NAME=U3.NAME AND')};
COPY=ADD10
=SQL{?W?' P3.GRANTEE_PRINCIPAL_ID')};
COPY=ADD10
=SQL{?W?'=U3.PRINCIPAL_ID')};
NAME=
*************************************************************
=M_SKIP:
*(PERMISSION_END)*
