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

Thread: copy user definition from one db to another

  1. 07-30-2003, 05:12 AM #1
    nabaig
    nabaig is offline Member
    Join Date
    Aug 2000
    Posts
    236

    copy user definition from one db to another

    I have more than 200 users whom I need to recreate in another database.
    what is the best way to generate/extract a user creation script?

    Thanks,

    Nizar
    Reply With Quote Reply With Quote
  2. 07-30-2003, 05:29 AM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    export/import
    Reply With Quote Reply With Quote
  3. 07-30-2003, 06:57 AM #3
    nabaig
    nabaig is offline Member
    Join Date
    Aug 2000
    Posts
    236
    I just need the user definition , tablespaces, roles, privileges etc.

    Not any objects they might own.

    Nizar
    Reply With Quote Reply With Quote
  4. 07-30-2003, 07:06 AM #4
    nabaig
    nabaig is offline Member
    Join Date
    Aug 2000
    Posts
    236
    I just need the user definition , tablespaces, roles, privileges etc.

    Not any objects they might own.

    Nizar
    Reply With Quote Reply With Quote
  6. 07-30-2003, 09:11 AM #5
    nabaig
    nabaig is offline Member
    Join Date
    Aug 2000
    Posts
    236
    I just need the user definition , tablespaces, roles, privileges etc.

    Not any objects they might own.

    Nizar
    Reply With Quote Reply With Quote
  7. 07-30-2003, 09:29 AM #6
    grjohnson's Avatar
    grjohnson
    grjohnson is offline Senior Advisor
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    Can anyone else in here, hear an ECHO.. echo.. echo..
    OCP 8i, 9i DBA
    Brisbane Australia
    Reply With Quote Reply With Quote
  8. 07-30-2003, 09:43 AM #7
    adewri's Avatar
    adewri
    adewri is offline Oracle Monk
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Hello Hello Hello Hello Hello Hello Hello is there anybody out there.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width