AutoCAD Map 3D

[#1]

Hi,

I am trying to use Autocad Map 3D 2012 with Postgis layers loaded using FDO.

I created a Postgis database user in order to be able to connect and control the access of the tables in the database, but when I have to choose the tables to add to the map in Autocad Map after i make the connection to the database, if the user is not set as superuser in the database, the tables appear in grey (unselectable) and it says “The feature class doesn´t exist”.

I understand that I need to grant permissions to some other postgis tables but I don´t know to which ones.

I tried using the FdoUserManager.exe installed in the Autocad Map installation to create the user but I have no choice to create a Postgis database user, I only have:

“”Welcome to FdoUserManager V3.0

Choose a provider:

  0) Exit.

  1) Autodesk FDO Provider for SQL Server  (version 3.5.0.0)

  2) OSGeo FDO Provider for SQL Server Spatial (version 3.5.0.0)

  3) Autodesk FDO Provider for Oracle  (version 3.5.0.0)

  4) OSGeo FDO Provider for MySQL  (version 3.5.0.0)””

Can anyone help me?

Regards,

Aitor

[#2]

Hi,

I am having the same issue to where I can connect to PostGIS using the superuser account, but nothing else.  Have you had any luck connecting to postgis with read only permissions?

Thanks

[#3]

Hi markvolz,

I haven't been able to achieve anything with a non superuser Postgis user.

I gave up when i wrote these posts in different forums and had no responses.

Please if you find any solution make me know.

Regards,

[#4]

Hi, I am able to get CAD users connected to PostGIS without the superadmin account. I have not evaluated the following SQL for security, but everything works great now. GRANT ALL ON SCHEMA public TO caduser; GRANT SELECT ON ALL TABLES IN SCHEMA public TO caduser; Mark Volz GIS Specialist