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:
1) Autodesk FDO Provider for SQL Server (version 126.96.36.199)
2) OSGeo FDO Provider for SQL Server Spatial (version 188.8.131.52)
3) Autodesk FDO Provider for Oracle (version 184.108.40.206)
4) OSGeo FDO Provider for MySQL (version 220.127.116.11)””
Can anyone help me?
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?
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.