Post reply

Permission to Login to grant permission to objects

  • August 10, 2007 at 9:49 pm

    #373151

    Hi,

    I have created a SQLLogin to access the databases given SELECT,INSERT,UPDATE,DELETE ,ALTER TABLE,CREATE TABLE and EXECUTE permissions.

    User can create table but cannot access the table and while accessing the table result into error "Permission denyed".

    What permission do i have to set so that user can access the newly created table.

    Regards

    Raj.

     

  • August 13, 2007 at 11:28 am

    #726552

    Try adding the user to db_datareader role.  Then you won't have to grant SELECT permission every time a table is created.

    Greg

    Greg

  • August 14, 2007 at 9:58 am

    #726851

    Thanks Greg.

Viewing 3 posts - 1 through 2 (of 2 total)

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