I have created a new database role "myNewRole" and wish to it to have select permissions on all tables and have grant persmissions to insert, delete ,update on several individual tables etc. I can add these ones no problem but when adding 'db_datareader' as a role i.e to get all select permissions I get error message (this is even for any other fixed roles)
Cannot find the object 'db_datareader', because it does not exist or you do not have permission.
The corresponding sql is
GRANT CONTROL ON ROLE::[db_datareader] TO [myNewRole] in scripter
any help guys ?