x

SQL Server LOGIN issue

I have created a sql server login for an application group consisting of 5 developers. After i created the user, i tested the connection including the previledges of the account on my machine. It has read and write access to the users, and worked as expcted on my machine. But when i gave the developers the credentials, and when the developer1 tried to connenct the database. he is able to connect but not access the tables through SSMS on his machine. This gets even more wierd, when the same login developer2 and developer 3 used it, they is able to access through the tables and browse through the tables.. and are able to what they were expected to do. I wanted to asssume that the developer1 had some configuration issues on his machine,but he is able to access(browse through the tables in SSMS) all the other databases on the instance without any issue. I am not sure what could have caused this problem? Anyone has encountered this type of issue. we are using SQL Server 2008
more ▼

asked Jan 03 '11 at 03:43 PM in Default

Katie 1 gravatar image

Katie 1
1.4k 129 163 202

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first
I have run into something similar to this occassionally. It usually happens when someone already has access to a given machine, possibly the same database, possibly other databases. After you update the permissions on the login you might need that user to log off the server entirely and log back on. I've seen it where if they were logged in, no amount of security changes would affect them.
more ▼

answered Jan 03 '11 at 07:19 PM

Grant Fritchey gravatar image

Grant Fritchey ♦♦
90.7k 19 21 74

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1816
x158
x81

asked: Jan 03 '11 at 03:43 PM

Seen: 731 times

Last Updated: Jan 03 '11 at 03:43 PM