Subject Problem with GRANT....it doesn't refresh
Author Antonio Natividad
Hi all:

I was creating users in my FB RC2 server (for linux)
and something is happening, if I change any permission
for an object(table for example) having an open
connection in ISQL(with user USER01) in another
computer, the changes of the permissions are not
respected until I disconect and connect my ISQL again.
For example:

If I have an open connection in ISQL(with user
USER01), and from another computer I change the
permission for TABLE1 object to SELECT only for my
user "USER01"

GRANT SELECT ON TABLE1 TO USER01;
REVOKE UPDATE ON TABLE1 FROM USER01;

this permissions are not respected in my ISQL
connection because it's still INSERTING rows.

What can I do?
Is it a bug or I'm doing something wrong?

Thanks a lot

_________________________________________________________
Do You Yahoo!?
Encuentra el coche de tus sueƱos en Yahoo! Autos http://autos.yahoo.com.mx