Post reply

Create Login with Select or Execute Permission

  • April 16, 2007 at 8:34 am

    #116708

    Hi All,

    I want to create login with following points

    1) User can execute only SELECT statements from query analyser , no DML statements

    Please help me for same.

    Thanking you in advance.

     

  • April 17, 2007 at 8:56 am

    #700938

    1. create a login, preferably one that uses Windows authentication

    2. create a database user by granting database access to the login

    3. give the user SELECT permission to the objects you want the user to       access or add the user as a member of the db_datareader fixed database role if you want the user to access all tables in a database

    You can do all of this in Enterprise Manager or use system stored procedures:

    sp_grantlogin, sp_grantdbaccess.

    By the way, you'll get more responses if you post in the SECURITY forum rather than this one, which is a testing forum.

    Greg

    Greg

  • April 18, 2007 at 7:12 am

    #701115

    Making the login db_datareader on the desired database would work as well, wouldn't it?

  • April 18, 2007 at 10:03 am

    #701158

    Yeah, if you want the user to be able to read all the user tables in the database.

    Greg

    Greg

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

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