Hi Lowell,

Thanks for your reply I have craeted role under CAS database..then grant select option and after that when I add rolemember then it shows me error

User or role 'ap' does not exist in this database. as 'ap' does not have any access of CAS database.

Am I creating role in right place?

Please help...