Re: GRANTing priveleges to a user?

SELECT * FROM practice09.customers;

because lellison owns no table customers

On 13 Feb 2002 23:18:23 -0800, akshaysalkar_at_joymail.com (DukeNM) wrote:

>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.

regards
Marc Blum
mailto:marc_at_marcblum.de
http://www.marcblum.de Received on Fri Feb 15 2002 - 14:23:48 CST