Thank you for all the responses, the views is an interesting idea. Creating a user, giving the user access to the database, then under securables on the database, then...

Excellent, I now see this in securables on the DB, been struggling with this one for a while thanks again for your help.

I created a SQL Authentication user, left defaults:

server role = public,

user mappings = schema datareader on the selected database

Database Role membership = public and datareader

Securables = (is this where control...

Hi Sean,

Thanks for your reply.

So do you suggest that I create a new user to use SQL Authentication? I don't seem to see anywhere that I can allow access...

Noticed there has been quite a few views of this post.

What I'm looking to find out is whether it is possible to restrict user access to a database table? I...