Author Topic: User requires ALTER permission on t_image  (Read 2335 times)

mgrube

  • EA Novice
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
User requires ALTER permission on t_image
« 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?

qwerty

  • EA Guru
  • *****
  • Posts: 10505
  • Karma: +231/-190
  • I'm no guru at all
    • View Profile
Re: User requires ALTER permission on t_image
« Reply #1 on: September 22, 2017, 12:53:44 am »
Most likely you have to consider EA security.

q.

mgrube

  • EA Novice
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Re: User requires ALTER permission on t_image
« Reply #2 on: September 22, 2017, 01:18:15 am »
Still no joy using Admin with all permissions in EA.

qwerty

  • EA Guru
  • *****
  • Posts: 10505
  • Karma: +231/-190
  • I'm no guru at all
    • View Profile
Re: User requires ALTER permission on t_image
« Reply #3 on: September 22, 2017, 04:40:56 am »
Look into %adddata%\...sparx...\dberror.txt. That might give a hint.

q.

bob.kleinig

  • EA Novice
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
Re: User requires ALTER permission on t_image
« Reply #4 on: April 18, 2018, 03:37:56 pm »
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.

Aaron B

  • EA Administrator
  • EA User
  • *****
  • Posts: 921
  • Karma: +14/-0
    • View Profile
Re: User requires ALTER permission on t_image
« Reply #5 on: April 18, 2018, 05:10:42 pm »
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

Uffe

  • EA Practitioner
  • ***
  • Posts: 1274
  • Karma: +93/-8
  • Flutes: 1; Clarinets: 1; Saxes: 5 and counting
    • View Profile
Re: User requires ALTER permission on t_image
« Reply #6 on: April 19, 2018, 06:13:59 pm »
The following fix works for 13.5.1352.

Code: (SQL) [Select]
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
My theories are always correct, just apply them to the right reality.

rchalie

  • EA Novice
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
Re: User requires ALTER permission on t_image
« Reply #7 on: September 05, 2019, 04:33:33 pm »
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?

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 9392
  • Karma: +258/-27
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: User requires ALTER permission on t_image
« Reply #8 on: September 05, 2019, 09:57:20 pm »
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

Paolo F Cantoni

  • EA Guru
  • *****
  • Posts: 6800
  • Karma: +142/-103
  • Inconsistently correct systems DON'T EXIST!
    • View Profile
Re: User requires ALTER permission on t_image
« Reply #9 on: September 06, 2019, 08:04:54 am »
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
Inconsistently correct systems DON'T EXIST!
... Therefore, aim for consistency; in the expectation of achieving correctness....
-Semantica-
Helsinki Principle Rules!

qwerty

  • EA Guru
  • *****
  • Posts: 10505
  • Karma: +231/-190
  • I'm no guru at all
    • View Profile
Re: User requires ALTER permission on t_image
« Reply #10 on: September 06, 2019, 08:50:51 am »
Right here!

q.

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 9392
  • Karma: +258/-27
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: User requires ALTER permission on t_image
« Reply #11 on: September 06, 2019, 01:51:43 pm »
The update SQL can be found here: https://www.sparxsystems.com/resources/repositories/index.html
Look for EASchema_1220_SQLServer_Update1.sql

Geert

qwerty

  • EA Guru
  • *****
  • Posts: 10505
  • Karma: +231/-190
  • I'm no guru at all
    • View Profile
Re: User requires ALTER permission on t_image
« Reply #12 on: September 06, 2019, 05:25:34 pm »
I guessed that Paolo was talking about the announcement of the change.

q.