SDE Permissions

[MikeLouwrens]

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.

[AsrujitSengupta · Accepted solution]

Only the data owner can manage, change privileges etc.

To create data, you need the below:

CREATE FUNCTION

CREATE PROCEDURE

CREATE TABLE

CREATE VIEW

[MikeLouwrens]

thanks for that, I'll take a look.

Cheers,

Mike.