Re: Oracle 10g not wrkng fine

shobhit_at_gmail.com wrote:
> Hii to all group members,
> I am new to Oracle 10g or say 10g is the first database wch I am
> learning so i have some big problems hopefully u people will solve
> them so thanks in advance to all senior members.
>
>
> P1 --> suppose i have a user with INSERT ANY TABLE privilige n after
> some time i use DROP USER username CASCADE so in this scenario if user
> insert somethng in any table then what will happen to that table n row
> because user is nw dropped.
>
> P2-->whats the difference between instance and session m nt
> understanding it properly.
>
> hopefully u people got my question verywell.
>
> thanks one more time...

If you want help here drop the illiteracy and use English. Not everyone here is an American (for which I am grateful) and not everyone here cares to decipher such nonsense (myself included).

Granting INSERT ANY TABLE is almost always a bad idea. One a record is committed it is committed.

Go to http://tahiti.oracle.com and read the concepts docs. Go to http://amazon.com and purchase all of Tom Kyte's books.

And if you want help in the future remember the first paragraph.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org