May 10, 2008 at 4:43 pm
I have an application in .NET for SQL SERVER 2000.
Was developed in 2 leyers.
In the server everything goes well.
In the clients I have trouble with accesing the database.
After some struggling I determined that the issue is to give permissions to GUEST for session start.
Question, why can't I see the users defined in the clients from the server with the sql server enterprise manager?
Second, if I define GUEST I can access the data base, but the system aborts because GUEST does not have permissions to the tables.
How do I grant permissions to the tables (other than going one by one clicking the boxes for SELECT, UPDATE, etc?
thanks
Homero
May 10, 2008 at 8:13 pm
Grant the Datareader and Datawriter DB roles to Guest.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply