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 |
|
jsimmons
Starting Member
14 Posts |
 Posted - 2004-10-27 : 16:53:30
|
| Hello to all!We recently introduced a new SQL Server database (after conversion from another platform). One of the business users (when attempting to run reports) receives the following error:Run-time error ' -2147217911 (80040e09)':[Microsoft][ODBC SQL Server Driver][SQL Server]SELECT permission denied on object 'site', database 'um_mex', owner 'dbo'.Can anyone assist?Thanks.......Joseph |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-10-27 : 17:01:15
|
| seems like a permissions problem. How do you have your permissions setup? Do you just grant everyone datareader, or do you have roles that you've created with specific permissions?-ec |
 |
|
|
jsimmons
Starting Member
14 Posts |
Posted - 2004-10-27 : 17:11:10
|
| We have roles created with specific permissions. However, when comparing them to another database with the permissions required, all looks identical with the "new" database.... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-10-27 : 18:11:51
|
| Right click on the object in EM, check out the permissions. Is anyone being denied the permission? Deny supercedes grants. You have a missing permission somewhere, either for the user or the role or a deny.Tara |
|
|
|
|
|
|
SQL Server error message