Author Topic: Database repository - single or multiple projects per database ?  (Read 5407 times)

RoyC

  • EA Administrator
  • EA Practitioner
  • *****
  • Posts: 1267
  • Karma: +16/-4
  • Read The Help!
    • View Profile
Re: Database repository - single or multiple projects per database ?
« Reply #30 on: December 13, 2019, 09:37:51 am »
Yeah. Wot he said I said.
Best Regards, Roy

Paolo F Cantoni

  • EA Guru
  • *****
  • Posts: 7263
  • Karma: +166/-115
  • Inconsistently correct systems DON'T EXIST!
    • View Profile
Re: Database repository - single or multiple projects per database ?
« Reply #31 on: December 13, 2019, 10:25:16 am »
Yeah. Wot he said I said.
No... It should have been "wot 'e said, I say"  When you write and we read; it is in the present tense...  ;)

Happy Friday everyone!

Paolo
Inconsistently correct systems DON'T EXIST!
... Therefore, aim for consistency; in the expectation of achieving correctness....
-Semantica-
Helsinki Principle Rules!

RoyC

  • EA Administrator
  • EA Practitioner
  • *****
  • Posts: 1267
  • Karma: +16/-4
  • Read The Help!
    • View Profile
Re: Database repository - single or multiple projects per database ?
« Reply #32 on: December 13, 2019, 04:59:13 pm »
No. KP was quoting me. So I wrote, in effect: "I agree with what he quoted (he said) me as saying a few years ago (I said)." And yes, I have changed the words.

Happy every day everybody.

Best Regards, Roy

Paolo F Cantoni

  • EA Guru
  • *****
  • Posts: 7263
  • Karma: +166/-115
  • Inconsistently correct systems DON'T EXIST!
    • View Profile
Re: Database repository - single or multiple projects per database ?
« Reply #33 on: December 13, 2019, 06:47:54 pm »
No. KP was quoting me. So I wrote, in effect: "I agree with what he quoted (he said) me as saying a few years ago (I said)." And yes, I have changed the words.

Happy every day everybody.
Isn't English wonderful...

Paolo
Inconsistently correct systems DON'T EXIST!
... Therefore, aim for consistency; in the expectation of achieving correctness....
-Semantica-
Helsinki Principle Rules!

Modesto Vega

  • EA User
  • **
  • Posts: 489
  • Karma: +14/-6
    • View Profile
Re: Database repository - single or multiple projects per database ?
« Reply #34 on: December 13, 2019, 09:59:03 pm »
English is wonderful, so it is the observation of the interactions among its speakers, especially when we are all more or less agreeing but still need a good old fashion disagreement to reinvigorate the heart.

Have a good and weekend.

Glassboy

  • EA Practitioner
  • ***
  • Posts: 1360
  • Karma: +110/-75
    • View Profile
Re: Database repository - single or multiple projects per database ?
« Reply #35 on: December 16, 2019, 07:06:56 am »
Yeah. Wot he said I said.
No... It should have been "wot 'e said, I say"  When you write and we read; it is in the present tense...  ;)

"wot they said" would be far more inclusive.  8)

Typia

  • EA User
  • **
  • Posts: 38
  • Karma: +0/-0
    • View Profile
Re: Database repository - single or multiple projects per database ?
« Reply #36 on: December 18, 2019, 12:43:56 am »
Hi guys !
Didn't expect to start a war :)

I think I'm much less skilled than you regarding databases.
I get the point that if security is managed only by EA, users with access to SQL management could bypass it and get / screw informations directly from the database.

Would the solution be to setup the authentification via Pro Cloud Server ?
Is Pro Cloud Server available without prolaborate ?
We might add prolaborate later but we first try to set up EA correctly before.

Many thanks


Geert Bellekens

  • EA Guru
  • *****
  • Posts: 10168
  • Karma: +329/-30
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Database repository - single or multiple projects per database ?
« Reply #37 on: December 18, 2019, 01:04:29 am »
I'm not sure if security is a good enough reason to use Pro Cloud Server (you can definitely buy that without Prolaborate)

I think it complicates things and doesn't add (much) security to the mix.

I would first try to set it up simple

- SQL Server with windows authentication
- EA (15) with AD integration for security groups
- Setup security with the option "Require user lock to edit"

Very often we also setup Remote Desktop (or the new WVD (Windows Virtual Desktop)), especially if you have remote users, or a slow network.
You can either allow a full desktop, or publish only EA.

Yes, a bad actor can still delete your whole database, but that is what backups are for.
Usually it's not the bad actor scenario's you have to worry about.

This setup is used by many of my clients and works really well.

Geert

Modesto Vega

  • EA User
  • **
  • Posts: 489
  • Karma: +14/-6
    • View Profile
Re: Database repository - single or multiple projects per database ?
« Reply #38 on: December 18, 2019, 03:42:33 am »
You did not start a war, just a bit of friendly digital group brawl, nothing that we have not done before  ;)

The setup described by Geert is very common and it is very similar to the one we are using in our team. The only thing that we do differently is that be use group locking, this allows us to restrict what particular users can do with specific areas/packages of the repository.