﻿* SET_DB_L.TXT HARASAWA (MySQL)
*********( CREATE USER )*************************************
=IF{_DB!='L'}JUMP{L_SKIP};
=MESSAGE{CREATE USER};
=SET{WC.HOST1=,WC.HOST2='@''?_SERVER_NAME?'''
=,WC.HOST3='@''LOCALHOST'''};
REPEAT=3
=LOGIN_SQL{CREATE USER PUBLIC?WC.HOST##? 
=  IDENTIFIED BY '?W_PASSWORD_ADMIN?'}
=  IF{_DB_ERROR!='L1396'}ERROR{?_DB_ERROR? ?_ERROR?};
=LOGIN_SQL{GRANT REFERENCES ON  *.*  TO PUBLIC?WC.HOST##?};
REPEAT=
*(PERMISSION_BEGIN)*
=IF{_DB!='L'}JUMP{L_SKIP};
=SET{_LOWER='MYSQL',W_MYSQL_L=_LOWER};
REPEAT0=$W0PERMISSION
REPEAT=2 (W_REAL_TEST##)
=SET{WPAS=W_PASSWORD_?W_REAL_TEST##?};
=SET{W0REPEAT2CNT=0};
REPEAT2=4 (W_DIOL--)
=COMPUTE{W0REPEAT2CNT+=1};
=IF{W0REPEAT2CNT=4}SET{WPAS=W_PASSWORD_LINK};
=SET{W_DIOL=W_DIOL?W0REPEAT2CNT?};
=SET{W_USER='?W_IS??W_R_T##?_?W_DIOL?_?W_PER$$?'};
=LOGIN_SQL{CREATE USER ?W_USER? IDENTIFIED BY '?WPAS?'}
=  IF{_DB_ERROR!='L1396'}ERROR{?_DB_ERROR? ?_ERROR?};
=LOGIN_SQL{GRANT SELECT     ON ?W_MYSQL_L?.*  TO ?W_USER?};
=LOGIN_SQL{GRANT REFERENCES ON           *.*  TO ?W_USER?};
=LOGIN_SQL{CREATE USER ?W_USER??WC.HOST2?
= IDENTIFIED BY '?WPAS?'}
=  IF{_DB_ERROR!='L1396'}ERROR{?_DB_ERROR? ?_ERROR?};
=LOGIN_SQL{GRANT SELECT     ON ?W_MYSQL_L?.*  TO 
= ?W_USER??WC.HOST2?};
=LOGIN_SQL{GRANT REFERENCES ON           *.*  TO
= ?W_USER??WC.HOST2?};
=LOGIN_SQL{CREATE USER ?W_USER??WC.HOST3?
= IDENTIFIED BY '?WPAS?'}
=  IF{_DB_ERROR!='L1396'}ERROR{?_DB_ERROR? ?_ERROR?};
=LOGIN_SQL{GRANT SELECT     ON ?W_MYSQL_L?.*  TO 
= ?W_USER??WC.HOST3?};
=LOGIN_SQL{GRANT REFERENCES ON           *.*  TO 
= ?W_USER??WC.HOST3?};
REPEAT0=
*********( CREATE SCEMA )************************************
=MESSAGE{CREATE SCHEMA};
REPEAT0=$W0PERMISSION
REPEAT=2  (W_R_T##=R;T)
=SET{W0REPEAT2CNT=0};
REPEAT2=2 (W_M_W=M;W)
=COMPUTE{W0REPEAT2CNT+=1}; 
=SET{W_M_W=W_M_W?W0REPEAT2CNT?};
=SET{_LOWER='?W_IS??W_R_T##?_?W_M_W?_?W_PER$$?'
=  ,W_SCHEMA=_LOWER};
=LOGIN_SQL{CREATE SCHEMA
=          IF NOT EXISTS ?W_SCHEMA? CHARACTER SET utf8}
=  ERROR{?_DB_ERROR? ?_ERROR?};
REPEAT0=
*************( GRANT ALL )***********************************
REPEAT0=$W0PERMISSION
=MESSAGE{GRANT ...(?W_PER$$?)};
REPEAT=3
=SET{W_PERX='ZZZZ'};
=SET{W0REPEAT2CNT=0};
REPEAT2=2 (W_PER--;ZZZZ;自分))
=COMPUTE{W0REPEAT2CNT+=1};
=IF{W0REPEAT2CNT=2}SET{W_PERX=W_PER$$};
=SET{_LOWER='?W_IS??W_RTT##?_M_?W_PER$$?'
=  ,W_SCHEMA_M_L=_LOWER};
=SET{_LOWER='?W_IS??W_RTT##?_W_?W_PER$$?'
=  ,W_SCHEMA_W_L=_LOWER};
=LOGIN_SQL{GRANT ALL PRIVILEGES ON ?W_SCHEMA_M_L?.* TO
=   ?W_IS?R_D_ZZZZ WITH GRANT OPTION};
=LOGIN_SQL{GRANT ALL PRIVILEGES ON ?W_SCHEMA_M_L?.* TO
=   ?W_IS??W_RRT##?_D_?W_PERX? WITH GRANT OPTION};
=LOGIN_SQL{GRANT ALL PRIVILEGES ON ?W_SCHEMA_W_L?.* TO
=   ?W_IS??W_RRT##?_D_?W_PERX? WITH GRANT OPTION};
=LOGIN_SQL{GRANT ALL PRIVILEGES ON ?W_SCHEMA_W_L?.* TO
=   ?W_IS??W_RRT##?_I_?W_PERX? WITH GRANT OPTION};
=LOGIN_SQL{GRANT ALL PRIVILEGES ON ?W_SCHEMA_W_L?.* TO
=   ?W_IS??W_RRT##?_O_?W_PERX? WITH GRANT OPTION};
=LOGIN_SQL{GRANT ALL PRIVILEGES ON ?W_SCHEMA_M_L?.* TO
=   ?W_IS?R_D_ZZZZ?WC.HOST2? WITH GRANT OPTION};
=LOGIN_SQL{GRANT ALL PRIVILEGES ON ?W_SCHEMA_M_L?.* TO
=   ?W_IS??W_RRT##?_D_?W_PERX??WC.HOST2? WITH GRANT OPTION};
=LOGIN_SQL{GRANT ALL PRIVILEGES ON ?W_SCHEMA_W_L?.* TO
=   ?W_IS??W_RRT##?_D_?W_PERX??WC.HOST2? WITH GRANT OPTION};
=LOGIN_SQL{GRANT ALL PRIVILEGES ON ?W_SCHEMA_W_L?.* TO
=   ?W_IS??W_RRT##?_I_?W_PERX??WC.HOST2? WITH GRANT OPTION};
=LOGIN_SQL{GRANT ALL PRIVILEGES ON ?W_SCHEMA_W_L?.* TO
=   ?W_IS??W_RRT##?_O_?W_PERX??WC.HOST2? WITH GRANT OPTION};
=LOGIN_SQL{GRANT ALL PRIVILEGES ON ?W_SCHEMA_M_L?.* TO
=   ?W_IS?R_D_ZZZZ?WC.HOST3? WITH GRANT OPTION};
=LOGIN_SQL{GRANT ALL PRIVILEGES ON ?W_SCHEMA_M_L?.* TO
=   ?W_IS??W_RRT##?_D_?W_PERX??WC.HOST3? WITH GRANT OPTION};
=LOGIN_SQL{GRANT ALL PRIVILEGES ON ?W_SCHEMA_W_L?.* TO
=   ?W_IS??W_RRT##?_D_?W_PERX??WC.HOST3? WITH GRANT OPTION};
=LOGIN_SQL{GRANT ALL PRIVILEGES ON ?W_SCHEMA_W_L?.* TO
=   ?W_IS??W_RRT##?_I_?W_PERX??WC.HOST3? WITH GRANT OPTION};
=LOGIN_SQL{GRANT ALL PRIVILEGES ON ?W_SCHEMA_W_L?.* TO
=   ?W_IS??W_RRT##?_O_?W_PERX??WC.HOST3? WITH GRANT OPTION};
=IF{W_PER$$='ZZZZ'}JUMP{J};
REPEAT2=
=J:
REPEAT0=
=JUMP{L_SKIP};
*****( OBJECT_VIEW )*****************************************
NAME=L_OBJECT_VIEW
=SET{WI=W_INSERT+'''L'','};
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')};
COPY=ADD10
=SQL{?W?' WHEN V.TABLE_NAME IS NULL THEN ''TABLE''')};
COPY=ADD10
=SQL{?W?' ELSE ''VIEW'' 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(UPPER(T.TABLE_NAME) AS CHAR(30))')};
COPY=ADD10
=SQL{?W?',CASE WHEN VIEW_DEFINITION IS NULL')};
COPY=ADD10
=SQL{?W?' THEN '' '' ELSE VIEW_DEFINITION END')};
COPY=ADD10
=SQL{?W?',CAST('' '' AS CHAR(17))')};
COPY=ADD10
=SQL{?W?',CAST('' '' AS CHAR(17))')};
COPY=ADD10
=SQL{?W?' FROM INFORMATION_SCHEMA.TABLES T')};
COPY=ADD10
=SQL{?W?' LEFT JOIN INFORMATION_SCHEMA.VIEWS V')};
COPY=ADD10
=SQL{?W?' ON T.TABLE_SCHEMA=V.TABLE_SCHEMA')};
COPY=ADD10
=SQL{?W?' AND T.TABLE_NAME=V.TABLE_NAME')};
COPY=ADD10
=SQL{?W?' WHERE T.TABLE_SCHEMA')};
COPY=ADD10
=SQL{?W?'=LOWER(''?W_L_DB?'') ')};
COPY=ADD10
=SQL{?W?' UNION SELECT')};
COPY=ADD10
=SQL{?W?' CAST(LEFT(ROUTINE_TYPE,4) 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(ROUTINE_NAME AS CHAR(30))')};
COPY=ADD10
=SQL{?W?',ROUTINE_DEFINITION')};
COPY=ADD10
=SQL{?W?',CAST('' '' AS CHAR(17))')};
COPY=ADD10
=SQL{?W?',CAST('' '' AS CHAR(17))')};
COPY=ADD10
=SQL{?W?' FROM INFORMATION_SCHEMA.ROUTINES ')};
COPY=ADD10
=SQL{?W?' WHERE ROUTINE_SCHEMA')};
COPY=ADD10
=SQL{?W?'=LOWER(''?W_L_DB?'') ')};
COPY=ADD10
=SQL{?W?' UNION SELECT CAST(''TRIG''  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(TRIGGER_NAME AS CHAR(30))')};
COPY=ADD10
=SQL{?W?',ACTION_STATEMENT')};
COPY=ADD10
=SQL{?W?',CAST('' '' AS CHAR(17))')};
COPY=ADD10
=SQL{?W?',CAST('' '' AS CHAR(17))')};
COPY=ADD10
=SQL{?W?' FROM INFORMATION_SCHEMA.TRIGGERS')};
COPY=ADD10
=SQL{?W?' WHERE TRIGGER_SCHEMA')};
COPY=ADD10
=SQL{?W?'=LOWER(''?W_L_DB?'')')};
*****( COLUMN_VIEW )*****************************************
NAME=L_COLUMN_VIEW
=SET{WI=W_INSERT+'''L'','};
=SET{_LOWER=' I_?_Q?_SYSTEM?_Q?_R_M_ZZZZ',W_SCHEMA=_LOWER};
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')};
COPY=ADD10
=SQL{?W?' CAST(''TABLE'' 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(UPPER(TABLE_NAME) AS CHAR(30))')};
COPY=ADD10
=SQL{?W?',CAST(ORDINAL_POSITION AS SIGNED)')};
COPY=ADD10
=SQL{?W?',CAST(COLUMN_NAME AS CHAR(30))')};
COPY=ADD10
=SQL{?W?',CAST(CASE')};
COPY=ADD10
=SQL{?W?' WHEN UPPER(DATA_TYPE)=''BIGINT''')};
COPY=ADD10
=SQL{?W?' THEN ''INT''')};
COPY=ADD10
=SQL{?W?' WHEN UPPER(DATA_TYPE)=''TIMESTAMP''')};
COPY=ADD10
=SQL{?W?' THEN ''DATETIME''')};
COPY=ADD10
=SQL{?W?' WHEN UPPER(DATA_TYPE)')};
COPY=ADD10
=SQL{?W?' IN(''CHAR'',''VARCHAR'',''LONGTEXT'')')};
COPY=ADD10
=SQL{?W?' THEN CASE ZZZZZZ_DEFAULT_TYPE')};
COPY=ADD10
=SQL{?W?' WHEN ''NCHAR'' THEN ''NCHAR''')};
COPY=ADD10
=SQL{?W?' WHEN ''NVARCHAR'' THEN ''NVARCHAR''')};
COPY=ADD10
=SQL{?W?' WHEN ''CHAR''  THEN ''CHAR''')};
COPY=ADD10
=SQL{?W?' WHEN ''VARCHAR''  THEN ''VARCHAR''')};
COPY=ADD10
=SQL{?W?' ELSE UPPER(DATA_TYPE) END ')};
COPY=ADD10
=SQL{?W?' ELSE UPPER(DATA_TYPE) END AS CHAR(9))')};
COPY=ADD10
=SQL{?W?',CAST(CASE UPPER(DATA_TYPE)')};
COPY=ADD10
=SQL{?W?' WHEN ''DECIMAL'' THEN NUMERIC_PRECISION')};
COPY=ADD10
=SQL{?W?' WHEN ''DATETIME'' THEN 17')};
COPY=ADD10
=SQL{?W?' WHEN ''TIMESTAMP'' THEN 17')};
COPY=ADD10
=SQL{?W?' WHEN ''DATE'' THEN 8  ')};
COPY=ADD10
=SQL{?W?' ELSE CASE')};
COPY=ADD10
=SQL{?W?' WHEN CHARACTER_MAXIMUM_LENGTH IS NULL THEN 9 ')};
COPY=ADD10
=SQL{?W?' WHEN CHARACTER_MAXIMUM_LENGTH>4000 THEN 4000')};
COPY=ADD10
=SQL{?W?' ELSE CHARACTER_MAXIMUM_LENGTH END END')};
COPY=ADD10
=SQL{?W?' AS SIGNED)')};
COPY=ADD10
=SQL{?W?',CAST(CASE UPPER(DATA_TYPE)')};
COPY=ADD10
=SQL{?W?' WHEN ''DECIMAL'' THEN NUMERIC_SCALE')};
COPY=ADD10
=SQL{?W?' ELSE 0 END AS SIGNED)')};
COPY=ADD10
=SQL{?W?',CAST(CASE')};
COPY=ADD10
=SQL{?W?' WHEN COLUMN_DEFAULT IS NULL THEN '' ''')};
COPY=ADD10
=SQL{?W?' WHEN COLUMN_DEFAULT='' ''')};
COPY=ADD10
=SQL{?W?' THEN '''''' ''''''')};
COPY=ADD10
=SQL{?W?' ELSE COLUMN_DEFAULT END AS CHAR(30))')};
COPY=ADD10
=SQL{?W?',CAST(CASE IS_NULLABLE')};
COPY=ADD10
=SQL{?W?' WHEN ''NO'' THEN ''0''')};
COPY=ADD10
=SQL{?W?' ELSE ''1'' END AS CHAR(1))')};
COPY=ADD10
=SQL{?W?' FROM INFORMATION_SCHEMA.COLUMNS')};
COPY=ADD10
=SQL{?W?' LEFT OUTER JOIN')};
COPY=ADD10
=SQL{?W?' ?W_SCHEMA?')};
COPY=ADD10
=SQL{?W?'.ZZZZZZ_I_DICTIONARY_TABLE')};
COPY=ADD10
=SQL{?W?' ON COLUMN_NAME=ZZZZZZ_DATA_NAME')};
COPY=ADD10
=SQL{?W?' AND ZZZZZZ_LANG=''?_LANG_SYSTEM?''')};
COPY=ADD10
=SQL{?W?' WHERE TABLE_SCHEMA')};
COPY=ADD10
=SQL{?W?'=LOWER(''?W_L_DB?'') ')};
*****( INDEX_VIEW )******************************************
NAME=L_INDEX_VIEW
=SET{WI=W_INSERT+'''L'','};
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(UPPER(TABLE_NAME) AS CHAR(30))')};
COPY=ADD10
=SQL{?W?',CAST(COLUMN_NAME AS CHAR(30))')};
COPY=ADD10
=SQL{?W?',CAST(CASE INDEX_NAME')};
COPY=ADD10
=SQL{?W?' WHEN ''PRIMARY'' THEN ''0''')};
COPY=ADD10
=SQL{?W?' ELSE RIGHT(INDEX_NAME,1) END AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(CASE NON_UNIQUE WHEN 0')};
COPY=ADD10
=SQL{?W?' THEN SEQ_IN_INDEX-1')};
COPY=ADD10
=SQL{?W?' ELSE SEQ_IN_INDEX END AS SIGNED) ')};
COPY=ADD10
=SQL{?W?' FROM INFORMATION_SCHEMA.STATISTICS')};
COPY=ADD10
=SQL{?W?' WHERE TABLE_SCHEMA')};
COPY=ADD10
=SQL{?W?'=LOWER(''?W_L_DB?'')')};
*****( GRANT_VIEW )******************************************
NAME=L_GRANT_VIEW
=SET{WI=W_INSERT+'''L'','};
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')};
COPY=ADD10
=SQL{?W?' DISTINCT CAST(''TABLE'' 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(UPPER(X1.TABLE_NAME) AS CHAR(30))')};
COPY=ADD10
=SQL{?W?',CAST(CASE X1.USER')};
COPY=ADD10
=SQL{?W?' WHEN ''PUBLIC'' THEN X1.USER')};
COPY=ADD10
=SQL{?W?' ELSE RIGHT(X1.USER,6) END AS CHAR(6))')};
COPY=ADD10
=SQL{?W?',CAST(CASE')};
COPY=ADD10
=SQL{?W?' FIND_IN_SET(''SELECT'',UPPER(X1.TABLE_PRIV))')};
COPY=ADD10
=SQL{?W?' WHEN 0 THEN '' '' ELSE ''S'' END AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(CASE')};
COPY=ADD10
=SQL{?W?' FIND_IN_SET(''INSERT'',UPPER(X1.TABLE_PRIV))')};
COPY=ADD10
=SQL{?W?' WHEN 0 THEN '' '' ELSE ''I'' END AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(CASE')};
COPY=ADD10
=SQL{?W?' FIND_IN_SET(''UPDATE'',UPPER(X1.TABLE_PRIV))')};
COPY=ADD10
=SQL{?W?' WHEN 0 THEN '' '' ELSE ''U'' END AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(CASE')};
COPY=ADD10
=SQL{?W?' FIND_IN_SET(''DELETE'',UPPER(X1.TABLE_PRIV))')};
COPY=ADD10
=SQL{?W?' WHEN 0 THEN '' '' ELSE ''D'' END AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST('' '' AS CHAR(1))')};
COPY=ADD10
=SQL{?W?' FROM MYSQL.TABLES_PRIV X1')};
COPY=ADD10
=SQL{?W?' LEFT OUTER JOIN MYSQL.TABLES_PRIV X2')};
COPY=ADD10
=SQL{?W?' ON X1.DB=X2.DB')};
COPY=ADD10
=SQL{?W?' AND X1.TABLE_NAME=X2.TABLE_NAME')};
COPY=ADD10
=SQL{?W?' AND X2.USER=''PUBLIC''')};
COPY=ADD10
=SQL{?W?' WHERE  X1.DB')};
COPY=ADD10
=SQL{?W?'=LOWER(''?W_L_DB?'')')};
COPY=ADD10
=SQL{?W?' AND (X1.USER=''PUBLIC''')};
COPY=ADD10
=SQL{?W?' OR LEFT(X1.USER,CHAR_LENGTH(X1.USER)-6)')};
COPY=ADD10
=SQL{?W?'=UPPER(LEFT(X1.DB,CHAR_LENGTH(X1.DB)-6)) ')};
COPY=ADD10
=SQL{?W?' AND (X2.USER IS NULL OR RIGHT(X1.USER,4)')};
COPY=ADD10
=SQL{?W?'=UPPER(RIGHT(X1.DB,4))')};
COPY=ADD10
=SQL{?W?' AND SUBSTRING(X1.USER')};
COPY=ADD10
=SQL{?W?',CHAR_LENGTH(X1.USER)-5,1)<>''L''')};
COPY=ADD10
=SQL{?W?' OR UPPER(X1.TABLE_PRIV)<>''SELECT''))')};
COPY=ADD10
=SQL{?W?' UNION DISTINCT SELECT ')};
COPY=ADD10
=SQL{?W?' CAST(LEFT(X1.ROUTINE_TYPE,4) 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(UPPER(X1.ROUTINE_NAME) AS CHAR(30))')};
COPY=ADD10
=SQL{?W?',CAST(CASE X1.USER')};
COPY=ADD10
=SQL{?W?' WHEN ''PUBLIC'' THEN X1.USER')};
COPY=ADD10
=SQL{?W?' ELSE RIGHT(X1.USER,6) END AS CHAR(6))')};
COPY=ADD10
=SQL{?W?',CAST('' '' AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST('' '' AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST('' '' AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST('' '' AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(CASE UPPER(X1.PROC_PRIV)')};
COPY=ADD10
=SQL{?W?' WHEN ''EXECUTE'' THEN ''E''')};
COPY=ADD10
=SQL{?W?' ELSE '' '' END AS CHAR(1))')};
COPY=ADD10
=SQL{?W?' FROM MYSQL.PROCS_PRIV X1')};
COPY=ADD10
=SQL{?W?' LEFT OUTER JOIN MYSQL.PROCS_PRIV X2')};
COPY=ADD10
=SQL{?W?' ON X1.DB=X2.DB')};
COPY=ADD10
=SQL{?W?' AND X1.ROUTINE_NAME=X2.ROUTINE_NAME')};
COPY=ADD10
=SQL{?W?' AND X2.USER=''PUBLIC'' ')};
COPY=ADD10
=SQL{?W?' WHERE  X1.DB')};
COPY=ADD10
=SQL{?W?'=LOWER(''?W_L_DB?'')')};
COPY=ADD10
=SQL{?W?' AND (X1.USER=''PUBLIC''')};
COPY=ADD10
=SQL{?W?' OR (LEFT(X1.USER,CHAR_LENGTH(X1.USER)-6)')};
COPY=ADD10
=SQL{?W?'=UPPER(LEFT(X1.DB,CHAR_LENGTH(X1.DB)-6))')};
COPY=ADD10
=SQL{?W?' AND (X2.USER IS NULL  OR RIGHT(X1.USER,4)')};
COPY=ADD10
=SQL{?W?'=UPPER(RIGHT(X1.DB,4))')};
COPY=ADD10
=SQL{?W?' AND SUBSTRING(X1.USER')};
COPY=ADD10
=SQL{?W?',CHAR_LENGTH(X1.USER)-5,1)<>''L'')))')};
NAME=
*************************************************************
=SET{_REAL_TEST='REAL'};
=L_SKIP:
*(PERMISSION_END)*
