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 |
|
scelamko
Constraint Violating Yak Guru
309 Posts |
 Posted - 2008-04-02 : 21:59:45
|
| Guys,I have 2 users emp_rw (read write) and emp_ro in the database through which application accesses the database. Now I would like to replace this users with roles and assign emp_rw, emp_ro to roles. Which roles should be created - database roles or application roles what is the difference between application and database roles.currently I execute the below statement to grant rights on database objects to emp and emp_ro users, can this be changed to grant rights to role instead of user.grant execute on <function name, procedure name> to emp_roAny suggestions and inputs would help.Thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-02 : 22:58:03
|
| Each db has builtin db_datareader and db_datawriter roles, you can find difference between application and database roles in books online. |
 |
|
|
|
|
|
Changing from users to roles