was: GRANTing priveleges to a user?

???

On Fri, 15 Feb 2002 21:29:25 -0000, "Paul Brewer" <paul_at_paul.brewers.org.uk> wrote:

>select 'Trolling' as purpose from dual;
>
>"Marc Blum" <marc_at_marcblum.de> wrote in message
>news:3c6d6dff.16126608_at_news.online.de...
>> 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
>
>

regards
Marc Blum
mailto:marc_at_marcblum.de
http://www.marcblum.de Received on Sat Feb 16 2002 - 08:25:02 CST