Sparx Systems Forum
Enterprise Architect => Bugs and Issues => Topic started by: mgrube on September 22, 2017, 12:49:08 am
-
I am attempting to load the image library to our SQL Server repository. I have a direct connection, and I have already granted (and verified) that the database user who is connecting has ALTER permissions on t_image. I still get the error message: "User requires ALTER permission on the t_image table in order to import model images." In previous topics I've found on the forum, granting ALTER permissions seems to have worked.
Any thoughts?
-
Most likely you have to consider EA security.
q.
-
Still no joy using Admin with all permissions in EA.
-
Look into %adddata%\...sparx...\dberror.txt. That might give a hint.
q.
-
I'm getting the same problem. I am able to update the T_IMAGE table directly using SQL Management Server, but cannot add images from within SparxEA. Nor can other users. We do not have EA Security turned on.
-
Please see:
http://www.sparxsystems.com/forums/smf/index.php/topic,38430.msg244153.html#msg244153
So I've just got some clarification that to fix this problem with SQL Server you need to apply an additional patch to the schema (EASchema_1220_SQLServer_Update1.sql). This update was just recently made available on our website (April 2018). In particular, please note that it requires all users to have EA 14 and is not backwards compatible. For more details, see:
http://www.sparxsystems.com/resources/corporate/index.html#sql_scripts
-
The following fix works for 13.5.1352.
USE The_database_name
GO
GRANT ALTER ON [dbo].[t_image] TO [The_user_name]
GO
Note that you need to grant the ALTER permission to every user in the database. We're using group-based logins and users, but if you're using individual logins/users per modeller, you'll have to grant the permission to all existing users, and remember to grant them when adding new ones as well.
/Uffe
-
As a former DBA I'm very curious as why it would be necessary for users to be able to modify a table in order to be able to insert or select rows from that table. Which design decision has led to this solution?
-
They have solved that since version 14.
There is an update SQL script available which, once executed, doesn't require alter permissions anymore to use EA.
Geert
-
They have solved that since version 14.
There is an update SQL script available which, once executed, doesn't require alter permissions anymore to use EA.
Geert
Where is that to be found, please?
Paolo
-
Right here!
q.
-
The update SQL can be found here: https://www.sparxsystems.com/resources/repositories/index.html (https://www.sparxsystems.com/resources/repositories/index.html)
Look for EASchema_1220_SQLServer_Update1.sql
Geert
-
I guessed that Paolo was talking about the announcement of the change.
q.