Creating a new role

Question

How do I create a new role in my database with my first name which is Denise, and add read only access on the HR user's EMPLOYEES table to this role.

Answer 1

From the documentation on MSDN for Create Role and Grant select

create role denise identified by appropriateVariable;

grant select on HR.employees to denise;

Answer 2

Using Adventureworks database as a reference, following shows sudo code

USE [AdventureWorks] 
GO  
CREATE ROLE [Denise] 
GO 
USE [AdventureWorks]  
GO  
GRANT SELECT ON [HumanResources].[Employee] TO [Denise]
GO