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 |
|
rum23
Yak Posting Veteran
77 Posts |
 Posted - 2009-02-02 : 14:26:37
|
| I want to do the folliwng in SQL Server 2005 Management studio. How do i do this?1. Create a new SQL Server database role called ABCAppRole in the database.2. Give the ABCAppRole role Delete, Insert, References, Select, Update and View Definition permissions on all ABC tables.3. Create a new SQL Server login called ABCSQLUser.4. Create a new database level user called ABCAppUser and associate it with the ABCSQLUser login created above.5. Give the ABCAppUser, the ABCAppRole role.The MS Access (front end) application will use this ABCAppUser login to access the SQL server database.Also, can this be done via SQL scripts? Please let me know how.thanks a bunch |
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2009-02-02 : 15:47:52
|
| http://www.microsoft.com/downloads/details.aspx?familyid=BE6A2C5D-00DF-4220-B133-29C1E0B6585F&displaylang=en |
 |
|
|
|
|
|
SQLserver database role