February 3, 2009 at 2:14 pm
I ran the following code, in the result I see N'db_datareader','db_datawriter', but my database is not checked cs_DotNetNuke,only N'db_datareader','db_datawriter', checked,what I am doing wrong?
USE [cs_DotNetNuke]
EXEC sp_addrolemember N'db_datareader', N'S602561DC4EW31\GPWebUser'
EXEC sp_addrolemember N'db_datawriter', N'S602561DC4EW31\GPWebUser'
February 3, 2009 at 2:32 pm
I am not sure if I understand the question entirely, but if you are trying to verify if the mentioned statements worked or not, try this:
Go to "cs_DotNetNuke\Security\Roles\Database Roles\db_dataeader", then right click on the db_datareader and select "properties".
You should see S602561DC4EW31\GPWebUser in the Role members list.
Also, it would be really helpful if you phrase the question properly. People shouldn't have to decipher the question.
Also, did you get any error message when you executed those statements?
Kindest Regards,
Shivaram Challa
(http://challa.net - Home of the "Excel to CSV converter & Browsepad applications".)
Forum Etiquette: How to post data/code on a forum to get the best help[/url]
February 4, 2009 at 5:41 am
I am sorry that you don't understand my question. I know how to check properties of the role, after the code runs and when I check properties, I see rolles are checked under the db, but db is not and I don't know why?Thank you
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply