nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

SQL database OS permissions

MohammedElsayed

We created an SQL database schema for a group of users to edit in, but the problem is when they login using the operating system they cannot see each others edits (ex. user X cannot see the feature classes that user Y created).

The question is: Is there any way to let all the users see each others using the operating system login?

Find more posts tagged with

Geodatabase

Database Access

Databases

Accepted answers

All comments

MohammedElsayed

thanks for your reply,

would you please explain how to create the group of users and how to add it to database?

the IT team created a group of users by when we tried to add it using CreateDatabaseUser tool it failed

George_Thompson

Ok, so each of the users will have grant permissions to the other O/S users (can use AD group) in order to see the new feature classes. Just cause you allowed an AD group to create objects (feature classes) in their own schema that they will be able to see the other objects without permission.

I would recommend that you have a data owner (i.e. GIS / DATA) as a DB user, then grant permissions to the AD group for editing.

MohammedElsayed

when creating the feature class by default it starts with the database name then the user name then the FC name (DBname\OSuserName\FCname)

the O/S users create the FC

George_Thompson

When they are creating the new feature classes, what is the naming convention being used?

Are the O/S users creating the feature classes or are they already created by a DB user?

MohammedElsayed

@YasserMahdy1 @YMahdy

MohammedElsayed

we are talking about new feature classes created in the schema

no there is no versioning employed

would you clarify the point of adding the FC to a role and what is the best permission design i should use?

DavidPike

Are we talking edits of existing features within a feature class or new feature classes created in the schema?

Is any type of versioning employed? If these a newly created feature classes, depending on your permissions design, the feature class would have to be added to a role - with the role being associated with a group of users.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.