GRANT SELECT ON <TABLENAME> TO <USERNAME> would work.
If you are creating multiple people that will have the same permissions you can setup a database role with those permissions. That way you can just add the users to the role.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply