Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: GRANTing priveleges to a user?
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
Received on Fri Feb 15 2002 - 15:29:25 CST