AutoCAD Map 3D General Discussion

AutoCAD Map 3D General Discussion

Reply
Active Member
agmartin
Posts: 10
Registered: ‎09-24-2012
Message 1 of 4 (414 Views)

Create a dababase user in Postgis for Autocad Map

414 Views, 3 Replies
12-19-2012 01:13 AM

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

 

 

Member
markvolz
Posts: 3
Registered: ‎01-09-2013
Message 2 of 4 (367 Views)

Re: Create a dababase user in Postgis for Autocad Map

01-17-2013 09:19 AM 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

Active Member
agmartin
Posts: 10
Registered: ‎09-24-2012
Message 3 of 4 (356 Views)

Re: Create a dababase user in Postgis for Autocad Map

01-17-2013 11:40 PM 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,

Member
markvolz
Posts: 3
Registered: ‎01-09-2013
Message 4 of 4 (336 Views)

Re: Create a dababase user in Postgis for Autocad Map

01-22-2013 06:54 AM 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
Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Do you have 60 seconds to spare? The Autodesk Community Team is revamping our site ranking system and we want your feedback! Please click here to launch the 5 question survey. As always your input is greatly appreciated.