>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. Set
