Subject RE: [firebird-support] no permission for read/select access to TABLE USERS
Author Svein Erling Tysvær
>Greetings, i have a new database which i populated with the membership tables and procedures using the 2.1 scripts.
>After that i decided not to use SYSDBA (everything works) and added a user and a role. I granted permissions then i saw that
>i couldn't run a procedure and then i noticed that i couldn't even select from a table USERS.
>I dropped the role and granted full access directly to the user.
>I get:
>Statement failed, SQLSTATE = 28000
>no permission for read/select access to TABLE USERS
>Any idea what's wrong?

Who were you logged on as when you granted the permissions? I typically use Database Workbench and know that I have a few times tried to grant access to tables to other users when I'm (accidentally) logged on as a user without WITH GRANT OPTION. I didn't get any exception, but of course, since the 'grantor' didn't have any rights to grant anything, the 'grantee' didn't receive any access rights.