topic Re: Accessing SQL Spatial Data from DBMS in Civil 3D Forum

Accessing SQL Spatial Data from DBMS

Anonymous — Mon, 08 Feb 2021 17:43:55 GMT

Hi there,

What are the requirements for AutoCAD Civil 3D to access only specific tables in a spatial database on a MS SQL Server, permission-wise? We tried granting INSERT, UPDATE, SELECT, DELETE to the specific tables, but the tables are not shown. db_datawriter probably grants access to all tables, but we would like to restrict the access to specific tables.

Background: We have a GIS department operating a large GIS-Database (ESRI) on MS SQL Server. We would like to read and write objects in some tables, but not all.

Thanks for any hint or advice

- Florian

Re: Accessing SQL Spatial Data from DBMS

rl_jackson — Mon, 08 Feb 2021 23:47:32 GMT

I could be wrong here but in most cases C3D/Map must have read write access at all times. I don't believe you can be selective in this.

Re: Accessing SQL Spatial Data from DBMS

Anonymous — Tue, 09 Feb 2021 08:11:45 GMT

Thanks for your answer, @rl_jackson !

What do you mean by "at all times"? Do we need access for the complete database? Do you have any documentation for that?

Re: Accessing SQL Spatial Data from DBMS

Anonymous — Tue, 16 Feb 2021 13:58:06 GMT

Anyone else, that could verify, that access can't be restricted to some tables?

Re: Accessing SQL Spatial Data from DBMS

rl_jackson — Wed, 17 Feb 2021 02:39:40 GMT

Maybe @lim.wendy could confirm this for you. I say this only because in most cases through all my years using AutoCad and its various incantations read/write access was required.

Re: Accessing SQL Spatial Data from DBMS

lim.wendy — Thu, 18 Feb 2021 00:42:42 GMT

Hi @Anonymous , @rl_jackson ,

Thanks for reaching out. From my understanding, you need read/write access but I could be wrong. Let me check with the experts and get back to you ...

Re: Accessing SQL Spatial Data from DBMS

Anonymous — Thu, 18 Feb 2021 07:51:27 GMT

Hi @rl_jackson , @lim.wendy

Thanks for your replies. Please remember my initial question: Can read/write access be restricted to some tables in a database or do we need full read/write access to the complete database?

Very curious what the experts say. Thanks in advance for checking!

Re: Accessing SQL Spatial Data from DBMS

Anonymous — Wed, 03 Mar 2021 16:38:10 GMT

Hi @lim.wendy,

Anything new from the experts?

Thanks!

Re: Accessing SQL Spatial Data from DBMS

lim.wendy — Thu, 04 Mar 2021 01:34:46 GMT

Hi @Anonymous,

Our experts have tested it, and have documented their findings in a knowledge article. We're making it live, which will take another day. I'll share the article link once it's available.

Appreciate your patience.

Re: Accessing SQL Spatial Data from DBMS

lim.wendy — Thu, 04 Mar 2021 09:45:32 GMT

Hi @Anonymous ,

The article is live now:

Minimum permission necessary for AutoCAD Map 3D or Civil 3D to work with SQL Server.

It has the steps for Permission at the Server Level and Permission at the Database Level