Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
paramu
Posting Yak Master
151 Posts |
 Posted - 2009-05-26 : 02:18:06
|
| My user name is userA, I created a database. But I want to give permission to UserB, to access my database with read & write & delete permissions. How to do it in Sqlserver 2005?Also I saw only 4-users can access at a time, but I want to give 20 users to access the permission. For that what we have to do?Helps are really appreciated.ThanksParamu @ PARANTHAMAN |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2009-05-26 : 02:22:04
|
| I take it UserB is a login?sp_adduser UserBthen you need to give UserB access to objects. Best to do this via a role rather than individually then you can give the same permissions to other users.Seecreate rolegrantsp_addrolememberin bolIt might be as easy as adding that role to the db_datareader and writer roles.Personally I try to never give users access to tables but give a stored procedure interface.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
paramu
Posting Yak Master
151 Posts |
Posted - 2009-05-27 : 01:37:43
|
| Thank You.......Multytimes.......Paramu @ PARANTHAMAN |
|
|
|
|
|
|
Add a user to access the database?