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?

Thank you


[Non-text portions of this message have been removed]