| Subject | Re: [firebird-support] FB3 No permission for usage access to exception |
|---|---|
| Author | hamacker |
| Post date | 2017-02-17T10:44:48Z |
grant to public and it will be resolved.
2017-02-16 10:59 GMT-02:00 rick@... [firebird-support] <firebird-support@yahoogroups.com>:
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?