SQL Select Permissions

Posted by Brandi on Stack Overflow See other posts from Stack Overflow or by Brandi
Published on 2010-05-25T21:03:04Z Indexed on 2010/05/25 21:11 UTC
Read the original article Hit count: 366

Filed under:
|
|
|
|

I have a database that I need to connect to and select from. I have an SQL Login, let's call it myusername. When I use the following, no SELECT permission shows up:

SELECT * FROM fn_my_permissions ('dbo.mytable', 'OBJECT')
GO

Several times I tried things like:

USE mydatabase
GO

GRANT SELECT TO myusername
GO

GRANT SELECT ON DATABASE::mydatabase TO myusername
GO

GRANT SELECT ON mytable TO myusername
GO

It says the queries execute successfully, but there is never any difference in the first query. What simple thing am I missing to grant database level select permissions.

As a note, I made double sure it was the correct user, correct database, and I have already tried granting table level select permissions. So far I keep getting the error:

SELECT permission denied on object 'mytable', database 'mydatabase', schema 'dbo'.

Any ideas what I'm missing? Thanks in advance.

© Stack Overflow or respective owner

Related posts about sql

Related posts about sql-server