topic Re: Prevent Users from Creating Feature Datasets in Geodatabase Questions

Prevent Users from Creating Feature Datasets

JoshBillings — Mon, 04 Dec 2023 21:16:27 GMT

We have a new Oracle SDE set up and we are trying to figure out why a named user account is able to create Feature Datasets. They are unable to create Feature Classes.

We want to prevent the named user from being able to create a Feature Dataset. Is there a privilege that needs to be revoked in order for this to happen?

Thanks,

Josh

Re: Prevent Users from Creating Feature Datasets

MarceloMarques — Mon, 04 Dec 2023 21:50:13 GMT

This is a known limitation and there is already an enhancement request logged for this.

Currently, there is no estimate if this will be implemented or when.

ENH-000152620 - Enterprise Geodatabase Editor & Viewer Users Shall Not Create Featuredatasets and Domains

Please, open a ticket with Esri Technical Support and request the enhancement as well, if more customers ask for the enhancement, then it increases the changes that the enhancement might get implemented.

I also want to clarify that the there is no current workaround for this issue. The changes need to be made in the application code, there is nothing in the database side, like permissions that we can set to prevent this from happening.

Visit my community.esri.com blog for more database best practices for Oracle Enterprise Geodatabases.

Mapping and Charting Solutions (MCS) Enterprise Databases Best Practices

Re: Prevent Users from Creating Feature Datasets

JoshBillings — Tue, 05 Dec 2023 13:22:09 GMT

Thanks @MarceloMarques !