Unable to login to the Web Console after upgrading from AppManager 6.x to version 7.x (NETIQKB71890)

All users other than AM Administrators receive the error message below when attempting to login to the AppManager Web Console after an upgrade from version 6.x:

Microsoft OLE DB Provider for SQL Server error '80004005'

EXECUTE permission denied on object 'xxxxx', database 'QDB', owner 'dbo'.

/netiq/GenericFunctions.inc, line 1527

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?.

 

Some Stored Procedures do not have Execute permission after the upgrade thus resulting in the error message above.

Formerly known as NETIQKB71890