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 |
|
psangeetha
Yak Posting Veteran
95 Posts |
 Posted - 2010-08-25 : 16:34:24
|
| Hi all, Is there a grant connect to database permission in sql server 2005? Or will the user get connect permission by default when the user is created in a database? Also the user will only have connect privilege in the database. We have an application role through which the user will get access to the objects in the database. Does this user need grant execute permission to execute an application role? Thank you very much |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
psangeetha
Yak Posting Veteran
95 Posts |
Posted - 2010-08-25 : 20:42:48
|
| Thanks. Does this user need grant execute permission to execute the application role? Thank you |
 |
|
|
|
|
|
grant permission