AutoCAD Map 3D General

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

Create a dababase user in Postgis for Autocad Map

377 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 (330 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 (319 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 (299 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

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

Ask the Community