Hi,

> I think you didn't understant my problem.
> Revoke is not about drop/delete table.

Believe me, Aage knows that.

> And table names can't be case sensitive in interbase.

Yes they can. So, what is the real table name?

> I must revoke rights from user.

Does "USER JOHN" help? Instead of just JOHN.


With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase & Firebird
Firebird Workbench - the developer tool for Firebird
Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

>
> > Ibrahim wrote:
> > >I tried this sql statement, but i get the error message
> > >REVOKE SELECT ON TABLE1 FROM JOHN
> >
> >
> > What is the name of the table you want to delete?
> > What is the name of the table you try to delete?
> > Do you use case sensitive tablenames?
> >
> >
> > Regards,
> > Aage J.