CSS Image Gallery Support Product Page
What is the difference between an Oracle schema, user and authdomain?
Shared 29 Mar 2023 13:48:11
likes this idea
29 Mar 2023 13:48:11 Michael Kurz posted:What is the difference between an Oracle schema, user and authdomain?
Replied 30 Mar 2023 14:26:40
30 Mar 2023 14:26:40 Sheena Owens replied:
In Oracle database we don't have any difference between schema and user both are the same. Each user = schema can have their own objects based on the grants given by Dba to the user
Replied 30 Mar 2023 18:31:02
30 Mar 2023 18:31:02 Albert Cooley replied:
I can say for sure that if you work a lot with Oracle schemas, then you will need a comparison and synchronization tool. What I like the most is the dbForge universal tool, as it can be used for oracle set schema and oracle schema compare. And also it will be a good helper if you need to make big changes to the database and analyze their impact.