Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Few users not exported by ora2pg #1272

Open
pjayasan opened this issue Oct 25, 2021 · 5 comments
Open

Few users not exported by ora2pg #1272

pjayasan opened this issue Oct 25, 2021 · 5 comments

Comments

@pjayasan
Copy link

Hi Team,
I am trying to export all users and grants from oracle using below command. Even though I 'have DBA privilege's to my ID few users has not been exported.I couldn't find any differences between the ID's that has been exported and not exported .
Please let me know if anything else need to be added.

ora2pg -t grant -o GTDM_grant.sql -b /home/pjayasan -c ora2pg.conf

Thanks in Advance!!!

@darold
Copy link
Owner

darold commented Oct 25, 2021

This is probably because Ora2Pg only export users that have privileges on the database objects. I will have a look.

@pjayasan
Copy link
Author

Is there any ways to export all the users available in oracle??

@darold
Copy link
Owner

darold commented Oct 25, 2021

Not yet, I will try to allow that in Ora2Pg in the week.

@pjayasan
Copy link
Author

pjayasan commented Nov 9, 2021

Any update on this??

@darold
Copy link
Owner

darold commented Nov 11, 2021

Not for the moment, actually this is not a high priority and as you can see there is lot of issues asking for enhancement.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants