Environment
Appmanager 7.x
AppManager 6.x
Situation
Microsoft OLE DB Provider for SQL Server error '80004005'
EXECUTE permission denied on object 'xxxxx', database 'QDB', owner 'dbo'.
/netiq/GenericFunctions.inc, line 1527
Resolution
In order to correct this issue please perform the following steps listed below on the Repository (QDB) database server:
1. Connect SQL Query Analyzer or SQL Management Studio to your Repository database.
2. Copy the following code to a new query
declare stand_user cursor
for
select U.UserName
from SUser U
inner join SRole R
on R.RoleID = U.RoleID
where R.RoleName = 'Standard User'
declare @user nvarchar(256)
open stand_user
fetch next from stand_user into @user
while(@@fetch_status = 0)
begin
exec GrantRevokeBasicExecute @user,'on'
fetch next from stand_user into @user
end
close stand_user
deallocate stand_user
Note:Please replace the 'standard user' role with the role that you assigned to users in security manager.
3. Run the query
4. Confirm that the message tab states ?Command completed successfully?.
Cause
Some Stored Procedures do not have Execute permission after the upgrade thus resulting in the error message above.