April 16, 2007 at 8:34 am
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
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
Making the login db_datareader on the desired database would work as well, wouldn't it?
April 18, 2007 at 10:03 am
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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy