﻿* SET_DB_D.TXT HARASAWA (Firebird)
*********( CREATE USER )*************************************
*(PERMISSION_BEGIN)*
=IF{_DB!='D'}JUMP{D_SKIP};
=MESSAGE{CREATE USER};
=COMMAND{ECHO LOG >?_TMP?D_LOG.TXT};
REPEAT0=$W0PERMISSION
REPEAT=2 (W_REAL_TEST##)
=SET{W0REPEAT2CNT=0};
=SET{WPAS=W_PASSWORD_?W_REAL_TEST##?};
=SET{W_CU='CREATEDB CREATEUSER'};
REPEAT2=4 (W_DIOL__)
=COMPUTE{W0REPEAT2CNT+=1};
=SET{W_DIOL=W_DIOL?W0REPEAT2CNT?};
=IF{W0REPEAT2CNT=4}SET{WPAS=W_PASSWORD_LINK};
=IF{W0REPEAT2CNT=2}SET{W_CU=};
=SET{W_COMMAND='-user ?W_LOGIN_ID? -pass ?W_PASSWORD_ADMIN?'
=+' -add ?W_IS??W_R_T##?_?W_DIOL?_?W_PER$$? -pw ?WPAS?'};
=COMMAND{"?$W_PROGRAM?" ?W_COMMAND? 2>>?_TMP?D_LOG.TXT};
REPEAT0=
*(PERMISSION_END)*
*********( CREATE DATABASE )******************************************************
=SET{W_DB=_INSTANCE+_P+'I'+_P+'DATABASE'+_P+_SYSTEM+'.I'+_P+'I_'+_SYSTEM+'.FDB'};
=SET{W_ISQL=$INSTALL_PATH+_P+'bin'+_P+'isql'+$W_EXE};
=WRITE1_OPEN{?_TMP?D.TXT}{OT}{/}WRITE1_CLOSE{}ERROR{};
=WRITE1{'CREATE DATABASE ''?W_DB?'' user ''?W_IS?R_D_ZZZZ'' password ''?W_PASSWORD_REAL?'';'};
=WRITE1{'EXIT;'};
=WRITE1_CLOSE{};
=COMMAND{"?W_ISQL?" -i ?_TMP?D.TXT 2>>?_TMP?D_LOG.TXT};
*********( ADD UDF  RTRIM(),e.t.c)*********************************************************
=COPY_FILE{?_TMP?D.TXT}{?$INSTALL_PATH??_P?UDF?_P?ib_udf.sql};
=COMMAND{"?W_ISQL?" -i ?_TMP?D.TXT -u ?W_IS?R_D_ZZZZ -p ?W_PASSWORD_REAL? ?W_DB?  2>>?_TMP?D_LOG.TXT};
*********( GRANT RDB$USER_PRIVERAGES )*********************************************************
=DBO_SQL{GRANT ALL    ON RDB$USER_PRIVILEGES TO I_?_SYSTEM?_R_D_ZZZZ};
=DBO_SQL{GRANT SELECT ON RDB$USER_PRIVILEGES TO PUBLIC};
********( CREATE VIEW )*************************************
*(PERMISSION_BEGIN)*
=JUMP{D_SKIP};
*****( OBJECT_VIEW )****************************************
NAME=D_OBJECT_VIEW
=SET{WI=W_INSERT+'''D'','};
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 T.RDB$RELATION_TYPE')};
COPY=ADD10
=SQL{?W?' WHEN 0 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(SUBSTRING(T.RDB$RELATION_NAME')};
COPY=ADD10
=SQL{?W?' FROM 2 FOR 1)AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(SUBSTRING(T.RDB$RELATION_NAME')};
COPY=ADD10
=SQL{?W?' FROM 3 FOR')};
COPY=ADD10
=SQL{?W?' CHAR_LENGTH(TRIM(T.RDB$RELATION_NAME))-2)')};
COPY=ADD10
=SQL{?W?' AS CHAR(30))')};
COPY=ADD10
=SQL{?W?',CAST(T.RDB$VIEW_SOURCE AS VARCHAR(4000))')};
COPY=ADD10
=SQL{?W?',CAST('' '' AS CHAR(17))')};
COPY=ADD10
=SQL{?W?',CAST('' '' AS CHAR(17))')};
COPY=ADD10
=SQL{?W?' FROM RDB$RELATIONS T  ')};
COPY=ADD10
=SQL{?W?' WHERE (T.RDB$RELATION_NAME LIKE')};
COPY=ADD10
=SQL{?W?' ''?W_D_OWNER1?%''')};
COPY=ADD10
=SQL{?W?'  OR T.RDB$RELATION_NAME LIKE')};
COPY=ADD10
=SQL{?W?' ''?W_D_OWNER2?%'')')};
COPY=ADD10
=SQL{?W?' UNION SELECT')};
COPY=ADD10
=SQL{?W?' CAST(''PROC'' 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(SUBSTRING(T.RDB$PROCEDURE_NAME')};
COPY=ADD10
=SQL{?W?' FROM 2 FOR 1) AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(SUBSTRING(T.RDB$PROCEDURE_NAME')};
COPY=ADD10
=SQL{?W?' FROM 3 FOR')};
COPY=ADD10
=SQL{?W?' CHAR_LENGTH(TRIM(T.RDB$PROCEDURE_NAME))-2)')};
COPY=ADD10
=SQL{?W?' AS CHAR(30))')};
COPY=ADD10
=SQL{?W?',CAST(T.RDB$PROCEDURE_SOURCE')};
COPY=ADD10
=SQL{?W?' AS VARCHAR(4000))')};
COPY=ADD10
=SQL{?W?',CAST('' '' AS CHAR(17))')};
COPY=ADD10
=SQL{?W?',CAST('' '' AS CHAR(17))')};
COPY=ADD10
=SQL{?W?' FROM RDB$PROCEDURES T')};
COPY=ADD10
=SQL{?W?' WHERE (T.RDB$PROCEDURE_NAME LIKE')};
COPY=ADD10
=SQL{?W?' ''?W_D_OWNER1?%''')};
COPY=ADD10
=SQL{?W?'  OR T.RDB$PROCEDURE_NAME LIKE')};
COPY=ADD10
=SQL{?W?' ''?W_D_OWNER2?%'')  ')};
COPY=ADD10
=SQL{?W?' UNION SELECT')};
COPY=ADD10
=SQL{?W?' CAST(''PROC'' 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(SUBSTRING(T.RDB$TRIGGER_NAME')};
COPY=ADD10
=SQL{?W?' FROM 2 FOR 1) AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(SUBSTRING(T.RDB$TRIGGER_NAME')};
COPY=ADD10
=SQL{?W?' FROM 3 FOR')};
COPY=ADD10
=SQL{?W?' CHAR_LENGTH(TRIM(T.RDB$TRIGGER_NAME))-2)')};
COPY=ADD10
=SQL{?W?' AS CHAR(30))')};
COPY=ADD10
=SQL{?W?',CAST(T.RDB$TRIGGER_SOURCE AS VARCHAR(4000))')};
COPY=ADD10
=SQL{?W?',CAST('' '' AS CHAR(17))')};
COPY=ADD10
=SQL{?W?',CAST('' '' AS CHAR(17))')};
COPY=ADD10
=SQL{?W?' FROM RDB$TRIGGERS T')};
COPY=ADD10
=SQL{?W?' WHERE (T.RDB$TRIGGER_NAME LIKE')};
COPY=ADD10
=SQL{?W?' ''?W_D_OWNER1?%''')};
COPY=ADD10
=SQL{?W?'  OR T.RDB$TRIGGER_NAME LIKE')};
COPY=ADD10
=SQL{?W?' ''?W_D_OWNER2?%'')')};
*****( COLUMN_VIEW )****************************************
NAME=D_COLUMN_VIEW
=SET{WI=W_INSERT+'''D'','};
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')};
COPY=ADD10
=SQL{?W?',ZZZZZZ_DEFAULT,ZZZZZZ_NULL)AS SELECT')};
COPY=ADD10
=SQL{?W?' CAST(CASE T.RDB$RELATION_TYPE')};
COPY=ADD10
=SQL{?W?' WHEN 0 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(SUBSTRING(T.RDB$RELATION_NAME')};
COPY=ADD10
=SQL{?W?' FROM 2 FOR 1)AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(SUBSTRING(T.RDB$RELATION_NAME')};
COPY=ADD10
=SQL{?W?' FROM 3 FOR')};
COPY=ADD10
=SQL{?W?' CHAR_LENGTH(TRIM(T.RDB$RELATION_NAME))-2)')};
COPY=ADD10
=SQL{?W?' AS CHAR(30)?_SQL_CHAR_SET?)')};
COPY=ADD10
=SQL{?W?',CAST(C.RDB$FIELD_POSITION+1 AS INT)')};
COPY=ADD10
=SQL{?W?',CAST(C.RDB$FIELD_NAME')};
COPY=ADD10
=SQL{?W?' AS CHAR(30)?_SQL_CHAR_SET?) ')};
COPY=ADD10
=SQL{?W?',CAST(CASE TY.RDB$TYPE_NAME ')};
COPY=ADD10
=SQL{?W?' WHEN ''TEXT''    THEN')};
COPY=ADD10
=SQL{?W?' CASE S.RDB$CHARACTER_SET_NAME')};
COPY=ADD10
=SQL{?W?' WHEN ''NONE'' THEN ''CHAR''')};
COPY=ADD10
=SQL{?W?' ELSE ''NCHAR'' END')};
COPY=ADD10
=SQL{?W?' WHEN ''VARYING'' THEN')};
COPY=ADD10
=SQL{?W?' CASE S.RDB$CHARACTER_SET_NAME')};
COPY=ADD10
=SQL{?W?' WHEN ''NONE'' THEN ''VARCHAR''')};
COPY=ADD10
=SQL{?W?' ELSE ''NVARCHAR'' END ')};
COPY=ADD10
=SQL{?W?' WHEN ''SHORT''   THEN ''INT''')};
COPY=ADD10
=SQL{?W?' WHEN ''TIMESTAMP'' THEN ''DATETIME''')};
COPY=ADD10
=SQL{?W?' WHEN ''LONG''    THEN')};
COPY=ADD10
=SQL{?W?' CASE WHEN F.RDB$FIELD_PRECISION=0 OR ')};
COPY=ADD10
=SQL{?W?' F.RDB$FIELD_PRECISION IS NULL THEN ''INT''')};
COPY=ADD10
=SQL{?W?' ELSE ''DECIMAL'' END ')};
COPY=ADD10
=SQL{?W?' ELSE  TY.RDB$TYPE_NAME END AS CHAR(9))')};
COPY=ADD10
=SQL{?W?',CAST(CASE WHEN F.RDB$FIELD_PRECISION>0')};
COPY=ADD10
=SQL{?W?' THEN F.RDB$FIELD_PRECISION ELSE')};
COPY=ADD10
=SQL{?W?' CASE TY.RDB$TYPE_NAME')};
COPY=ADD10
=SQL{?W?' WHEN ''LONG'' THEN 9')};
COPY=ADD10
=SQL{?W?' WHEN ''SHORT'' THEN 9')};
COPY=ADD10
=SQL{?W?' WHEN ''FLOAT'' THEN 9 ')};
COPY=ADD10
=SQL{?W?' WHEN ''DATE''  THEN 8')};
COPY=ADD10
=SQL{?W?' WHEN ''TIMESTAMP'' THEN 17 ')};
COPY=ADD10
=SQL{?W?' ELSE CASE S.RDB$CHARACTER_SET_NAME ')};
COPY=ADD10
=SQL{?W?' WHEN ''NONE'' THEN F.RDB$FIELD_LENGTH')};
COPY=ADD10
=SQL{?W?' ELSE F.RDB$FIELD_LENGTH/?_UTF8_GET?')};
COPY=ADD10
=SQL{?W?' END END END AS INT)')};
COPY=ADD10
=SQL{?W?',CAST(CASE WHEN F.RDB$FIELD_PRECISION>0')};
COPY=ADD10
=SQL{?W?' THEN 0-F.RDB$FIELD_SCALE ELSE 0 END AS INT)')};
COPY=ADD10
=SQL{?W?',CAST(SUBSTRING(C.RDB$DEFAULT_SOURCE')};
COPY=ADD10
=SQL{?W?' FROM 9 FOR')};
COPY=ADD10
=SQL{?W?' CHAR_LENGTH(TRIM(C.RDB$DEFAULT_SOURCE))-8)')};
COPY=ADD10
=SQL{?W?' AS CHAR(30)?_SQL_CHAR_SET?)')};
COPY=ADD10
=SQL{?W?',CAST(CASE C.RDB$NULL_FLAG')};
COPY=ADD10
=SQL{?W?' WHEN 1 THEN ''0'' ELSE ''1'' END AS CHAR(1))')};
COPY=ADD10
=SQL{?W?' FROM RDB$RELATIONS T')};
COPY=ADD10
=SQL{?W?' INNER JOIN RDB$RELATION_FIELDS C')};
COPY=ADD10
=SQL{?W?' ON C.RDB$RELATION_NAME=T.RDB$RELATION_NAME')};
COPY=ADD10
=SQL{?W?' INNER JOIN RDB$FIELDS F')};
COPY=ADD10
=SQL{?W?' ON F.RDB$FIELD_NAME=C.RDB$FIELD_SOURCE')};
COPY=ADD10
=SQL{?W?' INNER JOIN RDB$TYPES TY')};
COPY=ADD10
=SQL{?W?' ON TY.RDB$TYPE=F.RDB$FIELD_TYPE')};
COPY=ADD10
=SQL{?W?' AND TY.RDB$FIELD_NAME=''RDB$FIELD_TYPE''')};
COPY=ADD10
=SQL{?W?' INNER JOIN RDB$CHARACTER_SETS S')};
COPY=ADD10
=SQL{?W?' ON (S.RDB$CHARACTER_SET_ID')};
COPY=ADD10
=SQL{?W?'=F.RDB$CHARACTER_SET_ID')};
COPY=ADD10
=SQL{?W?' OR  S.RDB$CHARACTER_SET_ID=0')};
COPY=ADD10
=SQL{?W?' AND F.RDB$CHARACTER_SET_ID IS NULL)')};
COPY=ADD10
=SQL{?W?' WHERE (T.RDB$RELATION_NAME LIKE')};
COPY=ADD10
=SQL{?W?' ''?W_D_OWNER1?%''')};
COPY=ADD10
=SQL{?W?'  OR T.RDB$RELATION_NAME LIKE')};
COPY=ADD10
=SQL{?W?' ''?W_D_OWNER2?%'')')};
*****( INDEX_VIEW )*****************************************
NAME=D_INDEX_VIEW
=SET{WI=W_INSERT+'''D'','};
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(SUBSTRING(T.RDB$RELATION_NAME')};
COPY=ADD10
=SQL{?W?' FROM 2 FOR 1)AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(SUBSTRING(T.RDB$RELATION_NAME')};
COPY=ADD10
=SQL{?W?' FROM 3 FOR')};
COPY=ADD10
=SQL{?W?' CHAR_LENGTH(TRIM(T.RDB$RELATION_NAME))-2)')};
COPY=ADD10
=SQL{?W?' AS CHAR(30)?_SQL_CHAR_SET?)')};
COPY=ADD10
=SQL{?W?',CAST(C.RDB$FIELD_NAME')};
COPY=ADD10
=SQL{?W?' AS CHAR(30)?_SQL_CHAR_SET?)')};
COPY=ADD10
=SQL{?W?',CAST(RIGHT(TRIM(T.RDB$INDEX_NAME),1)')};
COPY=ADD10
=SQL{?W?' AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(C.RDB$FIELD_POSITION')};
COPY=ADD10
=SQL{?W?'+CASE RDB$UNIQUE_FLAG')};
COPY=ADD10
=SQL{?W?' WHEN 1 THEN 0 ELSE 1 END AS INT)')};
COPY=ADD10
=SQL{?W?' FROM RDB$INDICES T')};
COPY=ADD10
=SQL{?W?' INNER JOIN RDB$INDEX_SEGMENTS C')};
COPY=ADD10
=SQL{?W?' ON C.RDB$INDEX_NAME=T.RDB$INDEX_NAME')};
COPY=ADD10
=SQL{?W?' WHERE (T.RDB$RELATION_NAME LIKE')};
COPY=ADD10
=SQL{?W?' ''?W_D_OWNER1?%''')};
COPY=ADD10
=SQL{?W?' OR T.RDB$RELATION_NAME LIKE')};
COPY=ADD10
=SQL{?W?' ''?W_D_OWNER2?%'')')};
*****( GRANT_VIEW )*****************************************
NAME=D_GRANT_VIEW
=SET{WI=W_INSERT+'''D'','};
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?' CAST(CASE T.RDB$RELATION_TYPE ')};
COPY=ADD10
=SQL{?W?' WHEN 0 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(SUBSTRING(T.RDB$RELATION_NAME FROM')};
COPY=ADD10
=SQL{?W?' 2 FOR 1)AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(SUBSTRING(T.RDB$RELATION_NAME')};
COPY=ADD10
=SQL{?W?' FROM 3 FOR')};
COPY=ADD10
=SQL{?W?' CHAR_LENGTH(TRIM(T.RDB$RELATION_NAME))-2)')};
COPY=ADD10
=SQL{?W?' AS CHAR(30)?_SQL_CHAR_SET?)')};
COPY=ADD10
=SQL{?W?',CAST(CASE GS.RDB$USER')};
COPY=ADD10
=SQL{?W?' WHEN ''PUBLIC'' THEN ''PUBLIC'' ')};
COPY=ADD10
=SQL{?W?' ELSE RIGHT(TRIM(GS.RDB$USER),6)')};
COPY=ADD10
=SQL{?W?' END AS CHAR(6))')};
COPY=ADD10
=SQL{?W?',CAST(CASE GS.RDB$PRIVILEGE')};
COPY=ADD10
=SQL{?W?' WHEN ''S'' THEN ''S'' ')};
COPY=ADD10
=SQL{?W?' ELSE '' '' END AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(CASE GI.RDB$PRIVILEGE')};
COPY=ADD10
=SQL{?W?' WHEN ''I'' THEN ''I'' ')};
COPY=ADD10
=SQL{?W?' ELSE '' '' END AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(CASE GU.RDB$PRIVILEGE')};
COPY=ADD10
=SQL{?W?' WHEN ''U'' THEN ''U'' ')};
COPY=ADD10
=SQL{?W?' ELSE '' '' END AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(CASE GD.RDB$PRIVILEGE')};
COPY=ADD10
=SQL{?W?' WHEN ''D'' THEN ''D'' ')};
COPY=ADD10
=SQL{?W?' ELSE '' '' END AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST('' ''  AS CHAR(1))')};
COPY=ADD10
=SQL{?W?' FROM RDB$RELATIONS T')};
COPY=ADD10
=SQL{?W?' INNER JOIN RDB$USER_PRIVILEGES GS ')};
COPY=ADD10
=SQL{?W?' ON GS.RDB$RELATION_NAME')};
COPY=ADD10
=SQL{?W?'=T.RDB$RELATION_NAME')};
COPY=ADD10
=SQL{?W?' AND GS.RDB$PRIVILEGE=''S'' ')};
COPY=ADD10
=SQL{?W?' LEFT OUTER JOIN RDB$USER_PRIVILEGES GI ')};
COPY=ADD10
=SQL{?W?' ON GI.RDB$RELATION_NAME')};
COPY=ADD10
=SQL{?W?'=T.RDB$RELATION_NAME')};
COPY=ADD10
=SQL{?W?' AND GS.RDB$PRIVILEGE=''S''')};
COPY=ADD10
=SQL{?W?' AND GI.RDB$PRIVILEGE=''I''')};
COPY=ADD10
=SQL{?W?' AND GI.RDB$USER=GS.RDB$USER')};
COPY=ADD10
=SQL{?W?' LEFT OUTER JOIN RDB$USER_PRIVILEGES GU ')};
COPY=ADD10
=SQL{?W?' ON GU.RDB$RELATION_NAME')};
COPY=ADD10
=SQL{?W?'=T.RDB$RELATION_NAME')};
COPY=ADD10
=SQL{?W?' AND GS.RDB$PRIVILEGE=''S''')};
COPY=ADD10
=SQL{?W?' AND GU.RDB$PRIVILEGE=''U''')};
COPY=ADD10
=SQL{?W?' AND GU.RDB$USER=GS.RDB$USER')};
COPY=ADD10
=SQL{?W?' LEFT OUTER JOIN RDB$USER_PRIVILEGES GD ')};
COPY=ADD10
=SQL{?W?' ON GD.RDB$RELATION_NAME')};
COPY=ADD10
=SQL{?W?'=T.RDB$RELATION_NAME')};
COPY=ADD10
=SQL{?W?' AND GS.RDB$PRIVILEGE=''S''')};
COPY=ADD10
=SQL{?W?' AND GD.RDB$PRIVILEGE=''D''')};
COPY=ADD10
=SQL{?W?' AND GD.RDB$USER=GS.RDB$USER')};
COPY=ADD10
=SQL{?W?' WHERE (T.RDB$RELATION_NAME LIKE')};
COPY=ADD10
=SQL{?W?' ''?W_D_OWNER1?%''')};
COPY=ADD10
=SQL{?W?'  OR T.RDB$RELATION_NAME LIKE')};
COPY=ADD10
=SQL{?W?' ''?W_D_OWNER2?%'') ')};
COPY=ADD10
=SQL{?W?' AND (GS.RDB$USER=''PUBLIC'' OR')};
COPY=ADD10
=SQL{?W?' SUBSTRING(GS.RDB$USER  FROM ')};
COPY=ADD10
=SQL{?W?' CHAR_LENGTH(TRIM(GS.RDB$USER))-7 FOR 1)')};
COPY=ADD10
=SQL{?W?'=SUBSTRING(T.RDB$RELATION_NAME')};
COPY=ADD10
=SQL{?W?' FROM 1 FOR 1))')};
NAME=
****************************************************
=D_SKIP:
*(PERMISSION_END)*
