topic Re: Hide the database files in a SQL SDE database in ArcGIS Enterprise Questions

Hide the database files in a SQL SDE database

ChadKopplin — Tue, 28 Feb 2017 22:55:00 GMT

I would like to hide the database files in our SDE database. When I am in the database connection I see the feature datasets, feature classes, and the SQL SDE tables. Thank you for your help.

Re: Hide the database files in a SQL SDE database

JoeBorgione — Tue, 28 Feb 2017 22:57:59 GMT

That tells me :

1. Your login owns those

2. You didn't use sde user to set up your enterprise database

3. You did use sde user, and you are using him as your login (not a good practice)

Re: Hide the database files in a SQL SDE database

ChadKopplin — Tue, 28 Feb 2017 23:01:10 GMT

I used the DBO user to create the database, these files are created under the DBO user.

Re: Hide the database files in a SQL SDE database

JoeBorgione — Wed, 01 Mar 2017 00:02:26 GMT

And is your login part of the dbo group? I used dbo once to set up an enterprise geodatabase by mistake. I've always used sde to do that.

Re: Hide the database files in a SQL SDE database

ManviLather1 — Wed, 01 Mar 2017 00:37:43 GMT

Hello,

I understand that you are working with SQL server enterprise geodatabase with DBO schema and you want to hide the data present in an enterprise geodatabase from other users which are user mapped to the geodatabase.

Please correct me if I am wrong in understanding.

If you are data owner then you can grant and revoke the privileges of other users to select, insert, update and delete the data.

Here is a link for reference:

Grant and revoke dataset privileges—Help | ArcGIS Desktop

Also, have a look at the below link:

Privileges for geodatabases in SQL Server—Help | ArcGIS Desktop

Thanks

Re: Hide the database files in a SQL SDE database

ChadKopplin — Wed, 01 Mar 2017 15:11:27 GMT

Yes this is correct, I will take a look at this morning, thank you all for your assistance so far.

Re: Hide the database files in a SQL SDE database

ChadKopplin — Wed, 01 Mar 2017 15:11:56 GMT

Yes it is.

Re: Hide the database files in a SQL SDE database

ChadKopplin — Tue, 27 Feb 2018 18:39:28 GMT

I found out what the files are, the JTX files are job tracking files used with the Workflow extension, they are not database files from SQL like I thought. Thank you for the assistance.

Re: Hide the database files in a SQL SDE database

ChadKopplin — Tue, 27 Feb 2018 18:42:00 GMT

I removed the old extension, but the files are not removed from the geodatabase. I manually removed them from the geodatabase after the extension was removed.