AutoCAD Map 3D Forum
Welcome to Autodesk’s AutoCAD Map 3D Forums. Share your knowledge, ask questions, and explore popular AutoCAD Map 3D topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Create a dababase user in Postgis for Autocad Map

3 REPLIES 3
Reply
Message 1 of 4
agmartin
654 Views, 3 Replies

Create a dababase user in Postgis for Autocad Map

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

 

 

Tags (1)
3 REPLIES 3
Message 2 of 4
markvolz
in reply to: agmartin

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

Message 3 of 4
agmartin
in reply to: agmartin

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,

Message 4 of 4
markvolz
in reply to: agmartin

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

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report

”Boost