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