si_carter_987654321 wrote:
> I was after a utility to grant read/write/execute etc on all objects in one
> hit rather than individually
Well, you could simply generate GRANTs by querying the system tables and
then copy/paste results back to sql editor.
For example, this grants all privileges on all tables and views to all
users:
select 'Grant all on '||x.RDB$RELATION_NAME||' to PUBLIC;'
from RDB$RELATIONS x
where not exists (
SELECT 1
FROM RDB$USER_PRIVILEGES a
where a.RDB$USER = 'PUBLIC'
and a.RDB$RELATION_NAME = x.RDB$RELATION_NAME
)
and (x.RDB$SYSTEM_FLAG is null or x.RDB$SYSTEM_FLAG = 0)
You can write a similar one for procedures.
Regards,
--
Milan Babuskov
==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================
