Oracle roles export

[infolt]

Hi,

might be a dumb question, but how do you export oracle roles from working db to import them to development db? Or do I have to create them manually and only them use imp procedure to import data?

Great thanks in advance.

[oravijay]

Hi,

You will have to do a user level or database level export to export thsi.

Vijay.

[aarroyob]

If I have understood well, you want to export the roles assigned to a user in the database.

The only option to do this is export full=y, because this will create the user exactly it was. If not, you should create the user and grant all it need.

Cheers

Angel

[infolt]

Thank you, guys.