Sparx Systems Forum

Enterprise Architect => Bugs and Issues => Topic started by: GrantC on March 13, 2019, 07:43:44 pm

Title: 'User does not have permission to import model images' on Check Out
Post by: GrantC on March 13, 2019, 07:43:44 pm

Hi I'm using EA Corporate Edition v13.0.1306 with a SQL Server-based project and TFS for version control.

When I try and check out part of the model I usually get the message 'User does not have permission to import model images'.  Re-synching status with VC provider at this point shows the model is not checked out.  (In some areas of the model the checkout is successful but I get the error when checking back in).

Several other people here are using (I believe) the same setup successfully.

I found a couple of things online about this error regarding the t_image table.  One suggests giving my user ALTER permission on t_image - however I don't have a specific DB user set up, access is controlled with an AD group.  I could grant that user ALTER permissions, but as everyone uses the same group to log on I'd be surprised if that worked.

The other suggests creating an AD group called 'SQL Enterprise Architect Update' and doing this: GRANT ALTER ON [dbo].[t_image] TO [SQL Enterprise Architect Update].  Unfortunately getting an AD group created here isn't easy (and may not get approved at all), but I'm waiting on that in the meantime.

Any thoughts as to what the problem might be, or even how I can find more info to investigate?

Thanks

Title: Re: 'User does not have permission to import model images' on Check Out
Post by: Geert Bellekens on March 13, 2019, 07:59:48 pm

Grant,

If you are al working on version 14.1 there is an alternate solution.
Somewhere among the downloads there is an update SQL script that will change the database such that it no longer requires DDL admin rights to import images.

This altered database schema is not compatible with earlier versions of EA

Geert

Title: Re: 'User does not have permission to import model images' on Check Out
Post by: GrantC on March 13, 2019, 09:29:39 pm

Thanks Geert, unfortunately we're not on that version and I don't think an upgrade is going to happen anytime soon.

Do you know whether either of the suggested solutions is likely to work, before I start raising tickets?

Title: Re: 'User does not have permission to import model images' on Check Out
Post by: Geert Bellekens on March 13, 2019, 09:47:54 pm

I think you can ask your DBA people to add DDL-Admin as role to the AD group used in SQL server security.

I believe that should solve the problem.

Unless there is a problem with the security settings in EA. Make sure you have all the rights in EA's user configuration and try again. If you still have the same problem then it's at the database level and you should change the security settings there.

Geert

Title: Re: 'User does not have permission to import model images' on Check Out
Post by: GrantC on March 18, 2019, 04:35:47 am

So still waiting on getting DB permissions changed, but in the meantime I was given admin permissions temporarily in EA and stopped getting the error.  I would think this means it's an EA permissions thing rather than a database thing, however the administrator says my permissions in EA are set the same as everyone else's.

Any idea what permission in EA I might be lacking which would result in this image error?

Title: Re: 'User does not have permission to import model images' on Check Out
Post by: GrantC on March 19, 2019, 12:46:10 am

Update: ALTER TABLE permissions got granted on t_image and that seems to have done the trick.  Why this only happened for my user I don't know (the SQL login is based on a shared AD group), and why granting me admin rights in EA also worked adds to the confusion - but it's working now and that's the main thing!