topic Re: Master Geodatabase & User Schema geodatabase in Data Management Questions

Master Geodatabase & User Schema geodatabase

appsapps — Tue, 18 Mar 2014 06:13:26 GMT

We have a master geodatabase and 2 user-schema geodatabase (Projects & Survey namely);

From ArcCatalog - direct connect to "project" user-shcema GDB and choose SDE schema from the list.

Question:
Can I create feature class on SDE schema from user-schema connection?

1) If �?? YES then
Who will be the owner of the feature class? and
Where the table is get registered? In Master or User Schema GDB

2) If �?? NO then

We encounter situation here -

From ArcCatalog - direct connect to "project" user-shcema GDB and choose SDE schema from the list.
Action: -
Try to create new feature class �?? got an error message as below
�??Failed to create feature class.
User-schema owner cannot create/load data in master (SDE) instance�?�

Action �??
Click Ok on the above error message and
Try creating again now able to create without any error message?

Seems something wrong ? isn't?

Thanks in advance for your suggession

Re: Master Geodatabase & User Schema geodatabase

VinceAngelo — Tue, 18 Mar 2014 09:59:23 GMT

No, you cannot create tables in the SDE schema as a user-schema user.

A user-schema geodatabase is a contract that you'll:
1) Only create tables as that user in that schema
2) Never create tables in any other schema

If you think you've found a bug, please contact Tech Support.

- V

Re: Master Geodatabase & User Schema geodatabase

EmadAl-Mousa — Tue, 18 Mar 2014 14:43:45 GMT

Action: -
Try to create new feature class �?? got an error message as below
�??Failed to create feature class.
User-schema owner cannot create/load data in master (SDE) instance�?�

Action �??
Click Ok on the above error message and
Try creating again now able to create without any error message?

Seems something wrong ? isn't?

Thanks in advance for your suggession

try granting the user-schema geodatabase the oracle role "DBA" privilege, then check.

please update us after performing the grant.

Re: Master Geodatabase & User Schema geodatabase

VinceAngelo — Tue, 18 Mar 2014 14:54:23 GMT

DBA access is never necessary for normal ArcGIS operation. It is a dangerous security
practice to grant DBA unnecessarily, and there is no justification from this situation.

- V

Re: Master Geodatabase & User Schema geodatabase

appsapps — Tue, 08 Apr 2014 06:00:04 GMT

We got answer from ESRI for this issue!

This is a bug logged under NIM087273, The fix is available in 10.2.1 version.
Thanks for all suggestions