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






-Thanx Set for the reply, i was loggend in as SYSDBA. I granted everything with SYSDBA and then opened an isql command window connected as user and then tried a select statement.











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