Subject | Problem with GRANT....it doesn't refresh |
---|---|
Author | Antonio Natividad |
Post date | 2002-01-09T21:41:24Z |
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
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