DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Become User Privilege

  1. #1
    Join Date
    Jan 2000
    Location
    Silver Spring MD USA
    Posts
    105
    How does one use this privilege?
    What practical uses does it have?
    Any caveats?

    I'd appreciate input from those who have used it.

    thanks

  2. #2
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    Where did you read about this privilege "BECOME" ?
    I have never heard about this.
    Rajeev Suri

  3. #3
    Join Date
    Sep 2000
    Posts
    47
    I support a 3rd party app that uses this privilege to allow a proxy user to attach to the database and execute commands on behalf of the actual user. I don't like it (you abdicate control at the Oracle level), but a lot of apps seem to be going that way. Security is defined and implemented (supposedly!) in the app itself, and the proxy user is given "almost DBA" level privileges.

    There are both good and bad points, but (I believe) the main reason 3rd parties like to use it is that the app can be implemented to support multiple flavors of databases with less effort on the 3rd party developers part.

    Tim

  4. #4
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    well in that case it will be an application level privilege; It has nothing to do with Oracle privileges. The application grants some Oracle privileges when the "BECOME" privilege is granted to the user. The name "BECOME" is not very self-revealing though.

    - Rajeev
    Rajeev Suri

  5. #5
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by rsuri
    .... It has nothing to do with Oracle privileges....
    BECOME USER is a valid Orcale system privilege. Its main purpose is to enable one user to import other database users with import utility. It is required privilege for any user who wants to perform full import of the database, that is why it is granted to IMP_FULL_DATABASE role by default.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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