Image of what the discussion is about.

Steps to limit a user to choose only the Views they have permission for:

1. In Databases, Security, Logins - New Logins

Login Name: GISviewer (password) turn off password enforce policy

Default DB - RegDB User Mapping - RegDB

2. run tsql on the view GISWell

Use RegDB

GRANT SELECT ON vGISWell TO [GISviewer]

3 Open Access - External Data (Native SQL - add server name)

in data source UserName GISViewer Password: .....

Link Tables Result:

Only the dbo.vGISWell shows on top ' desired!

Plus.... Not Desired

All the Information_Schema.check_constraints

All of the sys.all_xxxx See link image above

Did the solution above Work?