SQLServerCentral / SQL Server Security Skills / Testing Center / Create Login with Select or Execute Permission / Latest Posts

RE: Create Login with Select or Execute Permission

Greg Charles — Wed, 18 Apr 2007 10:03:00 GMT

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

Greg

RE: Create Login with Select or Execute Permission

Mister Sachmo — Wed, 18 Apr 2007 07:12:00 GMT

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

RE: Create Login with Select or Execute Permission

Greg Charles — Tue, 17 Apr 2007 08:56:00 GMT

1. create a login, preferably one that uses Windows authentication2. create a database user by granting database access to the login3. 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

Create Login with Select or Execute Permission

Mukesh-366255 — Mon, 16 Apr 2007 08:34:00 GMT

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.