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 |
|
irislaw
Starting Member
7 Posts |
 Posted - 2006-12-12 : 14:10:35
|
| I am using an ERP system with SQL Server as the back end. When our user tried to run a function in ERP system, they got the following error:229,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]SELECT permission denied on object 'Grant', database 'HEI', owner 'dbo'I ran "sp_helprotect Grant" to check the permission, it looks okay.When I used the administrator's User ID to login to the machine and ran the same function in ERP, it works fine.Anyone knows how to fix it? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-12-12 : 14:27:01
|
| Run this to be sure:GRANT SELECT ON YourFunctionName TO TheUserHavingProblemsTara Kizer |
 |
|
|
|
|
|
Permission error