Thank you, Gail, for your answer. Now I'm trying to work out the correct syntax. It looks as though I should use the GRANT statement. I've created a custom role called NormalUsers, and I'm trying to add the db_datareader role to NormalUsers. This was the syntax I used:
GRANT db_datareader TO ROLE::NormalUsers TO AdventureWorks
But that doesn't work. When I run the above statement I get this error:
"Incorrect syntax near 'db_datareader'."
What have I done wrong?
Kindest Regards, Rod Connect with me on LinkedIn.