SDE Permissions

MikeLouwrens — Fri, 27 Nov 2015 02:23:18 GMT

We have always just used a single admin SQL account to create new feature classes in our SDE database (10.3 on SQL Server), however we have a non-admin user wanting to create and test some feature classes, so I'm wondering how I can give him access to create/delete his (and no other) feature classes without having to give him Database Owner permissions? Is this possible?

We're using OS Authentication, but could create a SQL user for him if that would work better?

Also the feature class he has managed to create (with DBO permissions) I am unable to change any permissions etc. on even with the SA account - can only do it from the account that created it. Is it possible for the DB Owner accounts (admin and SA) to set permissions on feature classes created by this other user?

Thanks,

Mike.

Re: SDE Permissions

AsrujitSengupta — Fri, 27 Nov 2015 07:45:24 GMT

Only the data owner can manage, change privileges etc.

To create data, you need the below:

CREATE FUNCTION

CREATE PROCEDURE

CREATE TABLE

CREATE VIEW

Re: SDE Permissions

MikeLouwrens — Sun, 29 Nov 2015 18:40:51 GMT

thanks for that, I'll take a look.

Cheers,

Mike.

topic Re: SDE Permissions in Geodatabase Questions

SDE Permissions

Re: SDE Permissions

Re: SDE Permissions