Hi! I have a database which was never intended to be used by more than one user, so it never concerned itself with access rights - basically, all objects were always created by that one user, who thus had a full access to them.
Now I find myself in need of using another user (because I need to write a trigger that behaves differently in two different situations, and I can't distinguish between the situations by using a field; so I plan to use a IF (CURRENT_USER='USER1') THEN ...). What would be the easiest way to give the new user full rights to all objects, and preferably also to all objects which will be created in the future? It seems to me that I would have to create a role, give full access to this role (how?), give this role to both my users, and then in the future keep adding rights to this role. It might actually be more feasible to say that one of those users will be a SYSDBA and do an IF (CURRENT_USER='SYSDBA') THEN ... Thanks, Josef ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
