|Subject||FB3 No permission for usage access to exception|
I'm confused about an error when accessing an FB3 database - "No permission for USAGE access to Exception E_Exception".
When I run a program while logged into database as SYSDBA I do not get this error.
I ran "grant usage on exception e_exception to user NICOLED" and "grant usage on exception e_exception to role WAREHOUSE".
When I look at RDB$USER_PRIVILEGES I can see RDB$RELATION_NAME for "E_EXCEPTION" with RDB$PRIVILEGE of "G".
I understand that FB3 now requires USAGE access to exceptions, but how do I grant it?