/*
 * Copyright (C) 1986-2010 Embarcadero Technologies, Inc
 * All Rights Reserved.
 */

/*--------------------------------------------------------------
 *	Grant SELECT-only access on system tables to PUBLIC
 *      System tables RDB$USERS and RDB$ENCRYPTIONS are
 *      intentionally not managed by this script for 
 *      security purposes
 *--------------------------------------------------------------
 */

REVOKE ALL    ON RDB$CHARACTER_SETS       FROM PUBLIC;
GRANT  SELECT ON RDB$CHARACTER_SETS       TO   PUBLIC;
REVOKE ALL    ON RDB$COLLATIONS           FROM PUBLIC;
GRANT  SELECT ON RDB$COLLATIONS           TO   PUBLIC;
REVOKE ALL    ON RDB$CHECK_CONSTRAINTS    FROM PUBLIC;
GRANT  SELECT ON RDB$CHECK_CONSTRAINTS    TO   PUBLIC;
REVOKE ALL    ON RDB$DATABASE             FROM PUBLIC;
GRANT  SELECT ON RDB$DATABASE             TO   PUBLIC;
REVOKE ALL    ON RDB$DEPENDENCIES         FROM PUBLIC;
GRANT  SELECT ON RDB$DEPENDENCIES         TO   PUBLIC; 
REVOKE ALL    ON RDB$EXCEPTIONS           FROM PUBLIC;
GRANT  SELECT ON RDB$EXCEPTIONS           TO   PUBLIC;
REVOKE ALL    ON RDB$FIELD_DIMENSIONS     FROM PUBLIC;
GRANT  SELECT ON RDB$FIELD_DIMENSIONS     TO   PUBLIC;
REVOKE ALL    ON RDB$FIELDS               FROM PUBLIC;
GRANT  SELECT ON RDB$FIELDS               TO   PUBLIC;
REVOKE ALL    ON RDB$FILES                FROM PUBLIC;
GRANT  SELECT ON RDB$FILES                TO   PUBLIC;
REVOKE ALL    ON RDB$FILTERS              FROM PUBLIC;
GRANT  SELECT ON RDB$FILTERS              TO   PUBLIC;
REVOKE ALL    ON RDB$FORMATS              FROM PUBLIC;
GRANT  SELECT ON RDB$FORMATS              TO   PUBLIC;
REVOKE ALL    ON RDB$FUNCTION_ARGUMENTS   FROM PUBLIC;
GRANT  SELECT ON RDB$FUNCTION_ARGUMENTS   TO   PUBLIC;
REVOKE ALL    ON RDB$FUNCTIONS            FROM PUBLIC;
GRANT  SELECT ON RDB$FUNCTIONS            TO   PUBLIC;
REVOKE ALL    ON RDB$GENERATORS           FROM PUBLIC;
GRANT  SELECT ON RDB$GENERATORS           TO   PUBLIC;
REVOKE ALL    ON RDB$INDEX_SEGMENTS       FROM PUBLIC;
GRANT  SELECT ON RDB$INDEX_SEGMENTS       TO   PUBLIC;
REVOKE ALL    ON RDB$INDICES              FROM PUBLIC;
GRANT  SELECT ON RDB$INDICES              TO   PUBLIC;
/* REVOKE ALL    ON RDB$JOURNAL_ARCHIVES     FROM PUBLIC;
GRANT  SELECT ON RDB$JOURNAL_ARCHIVES     TO   PUBLIC; */
REVOKE ALL    ON RDB$LOG_FILES            FROM PUBLIC;
GRANT  SELECT ON RDB$LOG_FILES            TO   PUBLIC;
REVOKE ALL    ON RDB$PAGES                FROM PUBLIC;
GRANT  SELECT ON RDB$PAGES                TO   PUBLIC;
REVOKE ALL    ON RDB$PROCEDURE_PARAMETERS FROM PUBLIC;
GRANT  SELECT ON RDB$PROCEDURE_PARAMETERS TO   PUBLIC;
REVOKE ALL    ON RDB$PROCEDURES           FROM PUBLIC;
GRANT  SELECT ON RDB$PROCEDURES           TO   PUBLIC;
REVOKE ALL    ON RDB$REF_CONSTRAINTS      FROM PUBLIC;
GRANT  SELECT ON RDB$REF_CONSTRAINTS      TO   PUBLIC;
REVOKE ALL    ON RDB$RELATION_CONSTRAINTS FROM PUBLIC;
GRANT  SELECT ON RDB$RELATION_CONSTRAINTS TO   PUBLIC;
REVOKE ALL    ON RDB$RELATION_FIELDS      FROM PUBLIC;
GRANT  SELECT ON RDB$RELATION_FIELDS      TO   PUBLIC;
REVOKE ALL    ON RDB$RELATIONS            FROM PUBLIC;
GRANT  SELECT ON RDB$RELATIONS            TO   PUBLIC;
REVOKE ALL    ON RDB$ROLES                FROM PUBLIC;
GRANT  SELECT ON RDB$ROLES                TO   PUBLIC;
REVOKE ALL    ON RDB$SECURITY_CLASSES     FROM PUBLIC;
GRANT  SELECT ON RDB$SECURITY_CLASSES     TO   PUBLIC;
REVOKE ALL    ON RDB$TRANSACTIONS         FROM PUBLIC;
GRANT  SELECT ON RDB$TRANSACTIONS         TO   PUBLIC;
REVOKE ALL    ON RDB$TRIGGER_MESSAGES     FROM PUBLIC;
GRANT  SELECT ON RDB$TRIGGER_MESSAGES     TO   PUBLIC;
REVOKE ALL    ON RDB$TRIGGERS             FROM PUBLIC;
GRANT  SELECT ON RDB$TRIGGERS             TO   PUBLIC;
REVOKE ALL    ON RDB$TYPES                FROM PUBLIC;
GRANT  SELECT ON RDB$TYPES                TO   PUBLIC;
REVOKE ALL    ON RDB$USER_PRIVILEGES      FROM PUBLIC;
GRANT  SELECT ON RDB$USER_PRIVILEGES      TO   PUBLIC;
REVOKE ALL    ON RDB$VIEW_RELATIONS       FROM PUBLIC;
GRANT  SELECT ON RDB$VIEW_RELATIONS       TO   PUBLIC;

COMMIT;
EXIT;