SDE Permissions

2896
2
Jump to solution
11-26-2015 06:23 PM
Highlighted
Occasional Contributor III

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.

0 Kudos
1 Solution

Accepted Solutions
Highlighted
Regular Contributor III

Only the data owner can manage, change privileges etc.

To create data, you need the below:

CREATE FUNCTION

CREATE PROCEDURE

CREATE TABLE

CREATE VIEW

View solution in original post

2 Replies
Highlighted
Regular Contributor III

Only the data owner can manage, change privileges etc.

To create data, you need the below:

CREATE FUNCTION

CREATE PROCEDURE

CREATE TABLE

CREATE VIEW

View solution in original post

Highlighted
Occasional Contributor III

thanks for that, I'll take a look.

Cheers,

Mike.

0 Kudos