Possible to grant users create FC permission when they are not owner of FD?

[ThomasColson]

Is it possible to allow users create feature class permissions in a feature dataset that was created by dbo? Here's the situation: I have created several feature datasets, I want users to be able to import/create their own data into those datasets. Creating a seperate FD per user is not feasible nor supported in our deployment model. E.g. we have one feature dataset named "Vegetation", all users in the organization need to have permissions to create feature classes within that FD. Creating a seperate FD for each user whom must create and edit vegetation feature classes just is not workable.

I'd tried given create table and alter dbo schema pemission in SQL, but I still get "You must be owner" errors when a user tries to create a FC in the FD I created for them. Environment is SQL 2008 Basic 64 bit SP1, ArcSDE 10 SP3.

[NanaDei]

Hi Tom,
The feature datasets are owned by 'dbo' due to the fact that the user who created the datasets is/was part of the 'sysadmin' role. The 'dbo' user concept is explained in the following Microsoft documentation.

For ArcSDE geodatabases, the owner of the dataset is the only user who can create/import feature classes into the dataset. The last statement from the following link can be reviewed. Granting users "CREATE TABLE" and "CREATE PROCEDURE" permissions will allow users to create data in the geodatabase and in feature datasets that they own. Users who own data in an ArcSDE geodatabase must also have the same name as their default schema. The following link can be reviewed for this information.

In your instance, it may be appropriate to have a single database user, eg. 'gisadmin' owning all data(feature datasets, feature classes, etc) in the geodatabase so that all users are not added to the 'sysadmin' role.

Thanks.