Symptom
Deleting a user in Tools>System Upkeep>User Security displays the following message and seems to loop back to this same message once a user in the same mill group to transfer objects to has been chosen.
Cause
A SQL trace will provide the following message
Resolution
The cause may be that the user exists in SQL security but does not have user mapping to either milldata or the millreports database.
Millennium expects a user to have both user mappings for milldata and millreports.
You can assign user mappings and then restart SQL services. Also admin can check to see if that user owns objects in SQL with the following select statement:
SELECT
TABLE_SCHEMA, count(*) as table_count
FROM
INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA <>'dbo'
group by TABLE_SCHEMA
order by TABLE_SCHEMA
If you still cannot delete the user, and administrator may need to remove the user from SQL security and also delete the user from the milldata>Userlist table with the following command
Delete from userlist where user_name = ‘username here’
Millennium expects a user to have both user mappings for milldata and millreports.
You can assign user mappings and then restart SQL services. Also admin can check to see if that user owns objects in SQL with the following select statement:
SELECT
TABLE_SCHEMA, count(*) as table_count
FROM
INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA <>'dbo'
group by TABLE_SCHEMA
order by TABLE_SCHEMA
If you still cannot delete the user, and administrator may need to remove the user from SQL security and also delete the user from the milldata>Userlist table with the following command
Delete from userlist where user_name = ‘username here’
Article Type
Product Info
Product Line
Millennium
Product Module/Feature
Administration
Ranking