19:
  20:
  21:-- This is script generates grants to public etc automatically
  22:-- See more extensive comments in alter_all.ddl for more info.
  23:
  24:
  25:set list on;
  26:set echo off;
  27:shell del autogrant.ddl;
  28:shell del grants_isql.txt;
  29:output autogrant.ddl;
  30:
  31:select 'GRANT ALL ON ' || RDB$RELATION_NAME || ' to public;'
  32:from RDB$RELATIONS
  33:where RDB$RELATION_NAME not starting with 'RDB$';
  34:
  35:select distinct 'GRANT ALL ON ' || RDB$VIEW_NAME || ' to public;'
  36:from RDB$VIEW_RELATIONS
  37:where RDB$VIEW_NAME not starting with 'RDB$';
  38:
  39:select distinct 'GRANT EXECUTE ON PROCEDURE ' || RDB$PROCEDURE_NAME || ' to public;'
  40:from RDB$PROCEDURES
  41:where RDB$PROCEDURE_NAME not starting with 'RDB$';
  42:
  43:output grants_isql.txt;
  44:set echo on;
  45:input autogrant.ddl;
  46:commit;
  47:
  48:
  49:
  50: