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 ?