Hi Gurus,

Am unable to the access on table even after providing the SELECT permission on table.

Used Query by me :

here Test is schema ; Card is table ; User is Satish

To grant select on Table

GRANT SELECT ON TEST.Card  TO satish

Even after this it is not working, So provided select on schema also.

used query : GRANT SELECT ON SCHEMA::TEST  TO Satish.

Please help me asap. Thanks in advance.

Yes, I have provided select access to user,Here "satish" is a user.

And the same user have been provided db_datareader still issue persists.

Done RND, still unable to retrive the data.

Here :- 

Database_name : Mumbai ;
Schema_name : Test  ;
Table_name : Card  ;
Login_Name : domain\Satish 

Note: The same user have provided access to table in another database, he is getting the data.

But going with the different database he is unable to fetch the data.(Note: both databases have different Schema's).

When i provided sysadmin for the Testing as this is a Test server, User is able to fetch the data.

Please suggest, I tried droping the user and creating once again from instance level and database level.

Still working on this, Your help will be useful.

Thanks Bro.

msg 229, Level 14, State 5, Line 1
The select permission was denied on the object 'Card', database 'Mumbai', schema 'test'.

Thansk in advance.

msg 229, Level 14, State 5, Line 1
The select permission was denied on the object 'Card', database 'Mumbai', schema 'test'.

Thansk in advance.

Hi Bro,

Here :- 

Database_name : Mumbai ;
Schema_name : Test  ;
Table_name : Card  ;
Login_Name : [domain\Satish] 

I have gave user mapping to login 'domain\Satish' to Database 'Mumbai'.

And from table level permissions for table 'Card' i have granted select for login 'domain\Satish'.

By using query :

Use Mumbai

Go

GRANT SELECT ON TEST.Card  TO  [domain\satish]

After this login [domain\satish] is unable to select the data from table TEST.Card

I have changed the schema and Database name because of security.

As of now i droped user and created again still facing the same issue, Tried giving DB_Datareader for login [domain\satish] in the database, He is still unable to getch the data.

When tested using SysAmin access to login [domain\satish] ,he is able to fetch, But revoke the access sysAdmin as per security policy.

Tried doing lot of RND , Still am unable to find the reason.

Please suggest. Thanks.

Have you also denied SELECT permissions on the table to a SQL Server role or Windows group? 

Keep in mind that permissions are cumulative, with DENY taking precedence over GRANT.  Even after granting select permissions, you will get a select permission denied error if the login is a member of Windows group or SQL Server role that has been denied SELECT permissions on the table.