Re: GRANTing priveleges to a user?

yes... exactly...what i wanted to know.
now..when i am connected to lellison and give the 'select' command ie. select * from customers;

it says no tables or no rows selected.
why?

i guess the grant is giving rights to lellison from the practice09 user to give the select command for the customers table rite?

jeremy.russell_at_usa.net (Jeremy Russell) wrote in message news:<3c694267.104014194_at_news.earthlink.net>...
> It allows the user connected as lellison (hmmm - where do I recognise
> that from) to add, change, remove and read rows in the CUSTOMERS
> table.
>
> More reading on your part might however be advisable - this is a
> rather basic question
>
>
> On 12 Feb 2002 03:30:40 -0800, akshaysalkar_at_joymail.com (DukeNM)
> wrote:
>
> >What does this do?
> >GRANT INSERT, UPDATE, DELETE, SELECT
> >ON customers
> >TO lellison;
> >
> >i am currently in the user/schema practice09.
Received on Thu Feb 14 2002 - 01:18:23 CST