Post reply

select permission denied to login number

  • December 12, 2012 at 5:39 am

    #266090

    i have provided db_datareader permission but still getting below error in sqlserver 2005 Dev Edition

    select permission denied to login [1234]

    Msg 229, Level 14, State 5, Line 1

    SELECT permission denied on object 'abc(table)', database 'xyz', schema 'dbo'.

  • December 12, 2012 at 6:13 am

    #1567845

    hi you can check using following way.

    please logon into sql using datareader login

    then exec sp_helprotect

    it will give no object accessible to him.

  • December 12, 2012 at 6:27 am

    #1567849

    Check for any deny's in sys.database_permissions for the object and user in question

    Deny will take over a Grant

  • December 12, 2012 at 7:31 am

    #1567890

    How can i give all tables select permissions in a DB with Login ID(1234)

  • December 12, 2012 at 7:33 am

    #1567892

    Grant the user db_datareader,

    But remember DENY takes over a GRANT, so if there is an explicit deny on the object they wont be able to select from it.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply