Hi there, i'm trying to build a sp or whatever to assign permissions to db objects to a user in one go.
I have defined tables (with constraints and also some indices), sp's, triggers, domains, views, generators and a couple of exceptions . So far i'm looking to RDB$RELATIONS table, for rows with RDB$FLAGS !=0 or not null for tables and views, RDB$PROCEDURES and RDB$TRIGGERS, to get object's names, but that's the beginning, i guess . Do i have to set permissions to all of them to such user o i shall exclude some type of objects ? Thanks in advance. Pablo
