SQL Parsing
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: SQL Parsing

  1. #1
    Join Date
    Feb 2002
    Posts
    267
    Lets say,

    user A queries

    select * from scott.emp;


    user B queries

    select * from scott.emp;

    But user B does not have previlages on scott.emp table.

    Since both the statements are identically same, does oracle parses the statement again
    or does it gets the info about the previleges from existing execution plan in the library cach to return the error?

    Regards
    sonia

  2. #2
    Join Date
    Feb 2002
    Posts
    267
    ?????

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    plz dont abuse

  4. #4
    Join Date
    Dec 1999
    Location
    Purgatory
    Posts
    346
    Pando,

    what do you mean by 'plz don't abuse' ?

  5. #5
    Join Date
    Sep 2000
    Posts
    305
    Well it will not parse the statement again.

  6. #6
    Join Date
    Feb 2002
    Posts
    267
    hi,
    then the user B has no preivilege on the table. But he has issued the same query., at what stage does it verifies that....

  7. #7
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    Hi
    Since both the statements are identically same, does oracle parses the statement again
    or does it gets the info about the previleges from existing execution plan in the library cach to return the error?
    I think that oracle would not reparse the statement, but always check the security. Because the securtiy can always change.

    The Explan-plan does not conatain security-information.
    The dictionary does.

    Orca




    [Edited by Orca777 on 07-12-2002 at 03:38 AM]

  8. #8
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    Originally posted by Horace
    Pando,

    what do you mean by 'plz don't abuse' ?
    I mean you dont have to spam to get an answer, if we know we will help you. Noone is forced to answer a question here

  9. #9
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    Hi pando;
    Sometimes it's good to not give up!
    I am a character often not asks, but
    who will not continue in asking ( hopefully the right questions )
    will not get the answer, the gift.

    Orca

  10. #10
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    Well noone here is blind or cant read isnt it?
    Itīs not about giving up asking, we read, if we can answer we do

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width