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 |
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
 Posted - 2013-07-30 : 14:39:05
|
| I need a query to grant the read only access permissions to the AD group on the view object without having granting access to underlying tables of the view object.The view had reference of other database table objects.Thanks for your help.. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
Posted - 2013-07-31 : 12:12:06
|
| Thanks Tara..User has access denied issue on the underlying table after the granting the view access.The view has dependant objects on other database tables on the same server..Do i need to grant access on uderlying tables as well. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
Posted - 2013-07-31 : 13:54:00
|
| Here is the user reported error when executing the view..The server principal "test\test" is not able to access the database "Dependent_view_table_database" under the current security context. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Access