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?
 

 

  

Reply via email to