Re: REvoke select rights.

2003-12-16 Thread Michael Stassen
Sohail Hasan wrote: Egor Egorov wrote: Sohail Hasan <[EMAIL PROTECTED]> wrote: I have created a database and created a user with select rights to that database, there is a table name xyz in that database that I don't want that user to view, that's why i want to revoke that select rights

Re: REvoke select rights.

2003-12-16 Thread Sohail Hasan
Egor Egorov wrote: Sohail Hasan <[EMAIL PROTECTED]> wrote: I have created a database and created a user with select rights to that database, there is a table name xyz in that database that I don't want that user to view, that's why i want to revoke that select rights from only that table,

Re: REvoke select rights.

2003-12-15 Thread Egor Egorov
Sohail Hasan <[EMAIL PROTECTED]> wrote: > > I have created a database and created a user with select rights to that > database, there is a table name xyz in that database that I don't want > that user to view, that's why i want to revoke that select rights from > only that table, can anyone

REvoke select rights.

2003-12-15 Thread Sohail Hasan
Hi All, I have created a database and created a user with select rights to that database, there is a table name xyz in that database that I don't want that user to view, that's why i want to revoke that select rights from only that table, can anyone tell me what syntax of revoke would be use