x

User and Roles - Permissions

I had assigned a user to a role and granted select permission on a table to the user. But the user says he is unable to select the table. Query is correct. what might be the problem.

more ▼

asked Mar 19 '10 at 05:58 AM in Default

Chandoo5599 gravatar image

Chandoo5599
118 6 6 7

Posting the actual message the user gets would help us answer you query. Is he 'unable' to connect or is he 'denied' or is the table not found?
Mar 19 '10 at 07:37 AM Fatherjack ♦♦
(comments are locked)
10|1200 characters needed characters left

3 answers: sort oldest

Have they been denied because of membership in a different role?

more ▼

answered Mar 19 '10 at 06:23 AM

Rob Farley gravatar image

Rob Farley
5.7k 15 18 20

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

Maybe the user is, or is in a role that has, explicitly been denied the permission?

It would also be helpful to see what the error message is that the user gets - relying on the user to say that they can't select isn't the best way!

more ▼

answered Mar 19 '10 at 06:22 AM

Kev Riley gravatar image

Kev Riley ♦♦
50.7k 43 49 76

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

DENY always overrides a GRANT so the I'd agree with Rob and check database role membership.

You don't say if you're using SQL or Windows authentication, but if you're using windows authentication, does your user belong to a Windows group that has different permissions?

more ▼

answered Mar 19 '10 at 06:29 AM

rich76 gravatar image

rich76
117 1 1 3

(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:

x83

asked: Mar 19 '10 at 05:58 AM

Seen: 925 times

Last Updated: Mar 19 '10 at 05:58 AM