exporting users/Roles/privs
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: exporting users/Roles/privs

  1. #1
    Join Date
    Nov 2000
    Posts
    198

    exporting users/Roles/privs

    Hi,
    I am trying to import a schema from dev to production.
    when I do an export(per schema) I don't get the users,roles,and privs. There must be a way to do that rather than create all users/roles/privs all over again ? the dev database has multiple
    schemas(instances) and I just want to export one of them.
    this is the way it is right now,
    1) the schema name is TIME and under that schema there are 5 users
    2) roles/privs are granted to these users based on needs.

    any idea ?

    Thanks.

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    try this

    1. Export FUll database.

    2. import full database using rowns=n ignore=y constraints=N INDEXES=N. This will create all your roles, schemas and grants

    HTH

    Amar
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    May 2002
    Location
    California, USA
    Posts
    175

    Thumbs up

    Or better

    full=y
    rows=n (no need for the data anyway) ...

    Then either open the *.dmp file and cut&paste the CREATE USER ..., GRANT .. which you need, or get DataBee tool (it will do that for you by using GUI). I believe That was the DataBee link


    Hope that helps,

    clio_usa - OCP 8/8i/9i DBA

    Visit our Web Site

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