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:
![]() | ![]() |