Create Login with Select or Execute Permission

• Mukesh-366255

  SSC Rookie

  Points: 46

  More actions

  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.

   

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  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

• Mister Sachmo

  SSCommitted

  Points: 1618

  More actions

  April 18, 2007 at 7:12 am

  #701115

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

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  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