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