Geoserver - empty native SRS field

Question

I'm converting layers from shape files to postgis with the below command:

shp2pgsql -s 22175 -c  -W "latin1" path/file.dbf' table_name db_name | psql -d db_name

Next, I add this layer to the GeoServer but the field native SRS is empty. I thought that the SRID were wrong so I run:

SELECT ST_SRID(geom) FROM table_name;

And to my surprise I get 22175 the conversion is not the problem. What I am doing wrong?

Note: already exits other layers have been added (by someone else) and that layers have the field native SRS filled with value EPSG:22175.

What am I doing wrong?

Answer 1

In my experience the native SRS field is empty usually because the user, as which Geoserver is accessing the database, does not have at least SELECT rights to the table.