hi All,

been playing with this for a while...

trying to add an existing fixed role to a new user defined role should work

exec sp_addrolemember @rolename = 'db_datareader', @membername='myNewRole'

but it does not and or trying to add 'db_datareader' as a securable does not work either...

but the following seems to

GRANT SELECT ON Schema::dbo to [myNewRole] can be added by this TSQL