Permission to Login to grant permission to objects

  • 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.

     

  • 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

  • Thanks Greg.

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

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