# Individual SQL Logins?

**URL:** <https://forum.servoy.com/t/individual-sql-logins/10686>\
**Category:** Classic Servoy\
**Created:** [May 20, 2009, 3:07pm UTC](https://forum.servoy.com/t/individual-sql-logins/10686 "2009-05-20T15:07:51Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![bubba](https://avatars.discourse-cdn.com/v4/letter/b/e9a140/32.png) [@bubba](https://forum.servoy.com/u/bubba)\
**Post date:** [May 20, 2009, 3:07pm UTC](https://forum.servoy.com/t/individual-sql-logins/10686/1 "2009-05-20T15:07:51Z")

</div>

Hi Folks:

Trolling back into Servoy water here as the product gets better with each release.

I’ve been out of the loop for awhile, but Yvo tells me that the current version of Servoy does support individual user Logins to the SQL database.

Can someone point me to where in the documentation this is described and how it’s implemented? This is important for our intended security model.

Thank you!  
Lee

---

<div class="post-metadata">

**Author:** ![bubba](https://avatars.discourse-cdn.com/v4/letter/b/e9a140/32.png) [@bubba](https://forum.servoy.com/u/bubba)\
**Post date:** [May 21, 2009, 4:11pm UTC](https://forum.servoy.com/t/individual-sql-logins/10686/2 "2009-05-21T16:11:04Z")

</div>

No one has any clue on this?

Is it just a misunderstanding from the Sales dept? ![;-)]( "Wink")

---

<div class="post-metadata">

**Author:** ![jmeunier](https://avatars.discourse-cdn.com/v4/letter/j/5e9695/32.png) [@jmeunier](https://forum.servoy.com/u/jmeunier)\
**Post date:** [May 21, 2009, 4:35pm UTC](https://forum.servoy.com/t/individual-sql-logins/10686/3 "2009-05-21T16:35:37Z")

</div>

Well, you could use individual logins by setting up a database server with each login you want to use, then during the login phase of your solution, you could use the switchServer function in the databaseManager node.

Jason

---

<div class="post-metadata">

**Author:** ![ROCLASI](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/roclasi/32/4371_2.png) [@ROCLASI](https://forum.servoy.com/u/ROCLASI)\
**Post date:** [May 21, 2009, 4:42pm UTC](https://forum.servoy.com/t/individual-sql-logins/10686/4 "2009-05-21T16:42:32Z")

</div>

That’s what I was thinking too but switchServer only works with already defined Servoy connections and you are not allowed to create several connections that connect to the same database (for obvious data-broadcast reasons). Not sure if the username differences (for those connections) make it a unique connection then, never tried it.

---

<div class="post-metadata">

**Author:** ![bubba](https://avatars.discourse-cdn.com/v4/letter/b/e9a140/32.png) [@bubba](https://forum.servoy.com/u/bubba)\
**Post date:** [May 21, 2009, 5:32pm UTC](https://forum.servoy.com/t/individual-sql-logins/10686/5 "2009-05-21T17:32:55Z")

</div>

They made it sound like this was a standard feature and being used by one of their larger accounts. So, something that involves a “trick” or a lot of extra setup does not sound right. I’ll have to press Yvo some more.

Regards,  
Lee

---

<div class="post-metadata">

**Author:** ![patrick](https://avatars.discourse-cdn.com/v4/letter/p/b2d939/32.png) [@patrick](https://forum.servoy.com/u/patrick)\
**Post date:** [May 21, 2009, 8:31pm UTC](https://forum.servoy.com/t/individual-sql-logins/10686/6 "2009-05-21T20:31:56Z")

</div>

Different users require different logins. That means you have to have different connections and it is possible to create those “duplicates” with different user names (almost sure ![:?]( "Confused") ). Downside is that you have more connections than are actually necessary on the database side as well. I wonder if large accounts really prefer to (believe to) be more secure when the downside is that they have to afford unnecessary connections. So maybe it is easier to convince them that a Servoy solution can also be made secure? But if it is really required (because maybe access rights should be maintained at one place) then it should be possible with switchServer.

---

<div class="post-metadata">

**Author:** ![ngervasi](https://avatars.discourse-cdn.com/v4/letter/n/f9ae1b/32.png) [@ngervasi](https://forum.servoy.com/u/ngervasi)\
**Post date:** [May 22, 2009, 7:40am UTC](https://forum.servoy.com/t/individual-sql-logins/10686/7 "2009-05-22T07:40:32Z")

</div>

Keep in mind that if you use switchServer you will have to setup all the autoenter options, table events, converters, etc for any defined server. All of them need to be in sync and that could be a real PITA if you have many db connections defined.

---

<div class="post-metadata">

**Author:** ![rgansevles](https://avatars.discourse-cdn.com/v4/letter/r/3d9bf3/32.png) [@rgansevles](https://forum.servoy.com/u/rgansevles)\
**Post date:** [May 25, 2009, 9:22am UTC](https://forum.servoy.com/t/individual-sql-logins/10686/8 "2009-05-25T09:22:54Z")

</div>

> ngervasi:  
> Keep in mind that if you use switchServer you will have to setup all the autoenter options, table events, converters, etc for any defined server. All of them need to be in sync and that could be a real PITA if you have many db connections defined.

Servoy will keep these in sync for you.

Table events and converters are defined on the main server and will be applied transparently to the switched-to server.  
For auto-enter options, there was a bug that the main server definition was not used on the switched-to server, this is fixed in release 4.1.3 which we expect to release this week.

Rob

---

<div class="post-metadata">

**Author:** ![ngervasi](https://avatars.discourse-cdn.com/v4/letter/n/f9ae1b/32.png) [@ngervasi](https://forum.servoy.com/u/ngervasi)\
**Post date:** [May 25, 2009, 9:28am UTC](https://forum.servoy.com/t/individual-sql-logins/10686/9 "2009-05-25T09:28:32Z")

</div>

> rgansevles:  
> For auto-enter options, there was a bug that the main server definition was not used on the switched-to server, this is fixed in release 4.1.3 which we expect to release this week.
> 
> Rob

You can’t imagine how grateful I am… ![:)]( "Smile")

Tnx Rob!

---

<div class="post-metadata">

**Author:** ![Harjo](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/harjo/32/4873_2.png) [@Harjo](https://forum.servoy.com/u/Harjo)\
**Post date:** [May 25, 2009, 12:18pm UTC](https://forum.servoy.com/t/individual-sql-logins/10686/10 "2009-05-25T12:18:39Z")

</div>

ow really?? ![:shock:]( "Shocked")

![:D]( "Very Happy") ![:D]( "Very Happy")

Also, new added columns?

---

<div class="post-metadata">

**Author:** ![rgansevles](https://avatars.discourse-cdn.com/v4/letter/r/3d9bf3/32.png) [@rgansevles](https://forum.servoy.com/u/rgansevles)\
**Post date:** [May 25, 2009, 12:44pm UTC](https://forum.servoy.com/t/individual-sql-logins/10686/11 "2009-05-25T12:44:06Z")

</div>

Harjo,

I am talking about the solution model (column info, aggregates, auto-enter options, etc), not about the data model.  
Servoy \<= 4.1 expects the data models to be the same.

In Servoy 4.2 we introduce a new feature where multiple server data models are updated with 1 import.

Rob

---

<div class="post-metadata">

**Author:** ![Harjo](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/harjo/32/4873_2.png) [@Harjo](https://forum.servoy.com/u/Harjo)\
**Post date:** [May 25, 2009, 12:50pm UTC](https://forum.servoy.com/t/individual-sql-logins/10686/12 "2009-05-25T12:50:09Z")

</div>

oke great! Thanks…

---

<div class="post-metadata">

**Author:** ![Kahuna](https://avatars.discourse-cdn.com/v4/letter/k/8491ac/32.png) [@Kahuna](https://forum.servoy.com/u/Kahuna)\
**Post date:** [May 25, 2009, 1:46pm UTC](https://forum.servoy.com/t/individual-sql-logins/10686/13 "2009-05-25T13:46:11Z")

</div>

> rgansevles:  
> Harjo,
> 
> I am talking about the solution model (column info, aggregates, auto-enter options, etc), not about the data model.  
> Servoy \<= 4.1 expects the data models to be the same.
> 
> In Servoy 4.2 we introduce a new feature where multiple server data models are updated with 1 import.
> 
> Rob

Sorry to hi-Jack but could you expand on this please Rob - do you mean if I switch server the solution will update each of the server’s I connect to with data structure changes?

If not what is the best method of updating the multiple servers that I might switch to?

---

<div class="post-metadata">

**Author:** ![rgansevles](https://avatars.discourse-cdn.com/v4/letter/r/3d9bf3/32.png) [@rgansevles](https://forum.servoy.com/u/rgansevles)\
**Post date:** [May 25, 2009, 2:16pm UTC](https://forum.servoy.com/t/individual-sql-logins/10686/14 "2009-05-25T14:16:05Z")

</div>

Ian,

In 4.2 we have a new attribute in server definition that links one server to another (‘is a clone of’).  
When an import in the main server has data structure changes, these will be applied in the ‘clone’ servers as well.

This setting is only used while importing solutions.

Rob

---

<div class="post-metadata">

**Author:** ![Riccardino](https://avatars.discourse-cdn.com/v4/letter/r/41988e/32.png) [@Riccardino](https://forum.servoy.com/u/Riccardino)\
**Post date:** [May 25, 2009, 7:51pm UTC](https://forum.servoy.com/t/individual-sql-logins/10686/15 "2009-05-25T19:51:23Z")

</div>

> ngervasi:
> 
> > rgansevles:  
> > For auto-enter options, there was a bug that the main server definition was not used on the switched-to server, this is fixed in release 4.1.3 which we expect to release this week.
> > 
> > Rob
> 
> You can’t imagine how grateful I am… ![:)]( "Smile")

Me too ![;-)]( "Wink")

Thanks, Rob.

---

<div class="post-metadata">

**Author:** ![Jan\_Aleman](https://avatars.discourse-cdn.com/v4/letter/j/4af34b/32.png) [@Jan\_Aleman](https://forum.servoy.com/u/Jan_Aleman)\
**Post date:** [May 25, 2009, 8:44pm UTC](https://forum.servoy.com/t/individual-sql-logins/10686/16 "2009-05-25T20:44:21Z")

</div>

> bubba:  
> They made it sound like this was a standard feature and being used by one of their larger accounts. So, something that involves a “trick” or a lot of extra setup does not sound right. I’ll have to press Yvo some more.
> 
> Regards,  
> Lee

There is no trick it is a standard feature and not hard to setup at all.Having said that: yes using a 2-tier approach (which you are essentially doing) in an n-tier world will always be more work than just working with the n-tier rules in the n-tier world! .  
Ofcourse you loose one of our coolest features: databroadcasting, think about an n-tier architecture and you will understand how much work this would be to automagically understand to how your underlying oracle connection is connecting to which physical table: next to impossible, there’s a million ways of doing it (trust me I’m an ex oracle db, I know what I’m talking about)

---

<div class="post-metadata">

**Author:** ![pbakker](https://avatars.discourse-cdn.com/v4/letter/p/a4c791/32.png) [@pbakker](https://forum.servoy.com/u/pbakker)\
**Post date:** [May 26, 2009, 8:16am UTC](https://forum.servoy.com/t/individual-sql-logins/10686/17 "2009-05-26T08:16:51Z")

</div>

As some extra info: for databroadcasting to work properly there can only be one database server connection defined in Servoy that points to a physical database (schema/catalog).

In other words, a (set of ) tables should only be accessible through one Database Server connection.

If you have multiple Database Server connections defined that can access the same table, databroadcast will not work between the different connections. so, if you have three clients, all accessing table customers, where client 1 and 2 do this over database server connection S1 and client 3 does it over database server connection S2, if client 3 does an insert/delete/update on the table, clients 1 and 2 won’t be notified. If client 1 does the insert/update/delete, client 2 will be notified (as he is accessing the data through the same database server connection), but client 3 will not be notified.

Hope this makes it clearer,

Paul

---

<div class="post-metadata">

**Author:** ![bubba](https://avatars.discourse-cdn.com/v4/letter/b/e9a140/32.png) [@bubba](https://forum.servoy.com/u/bubba)\
**Post date:** [May 28, 2009, 1:18pm UTC](https://forum.servoy.com/t/individual-sql-logins/10686/18 "2009-05-28T13:18:33Z")

</div>

Jan and Paul:

Thanks for the additional info. The loss of broadcasting is a big drawback, but not insurmountable.

In a single connection model, does the “Table Filtering” feature of Servoy operate at the SQL Database level on an individual user basis, or is this filtering being done within the “Servoy” code, cache.

Thanks,  
Lee

---

<div class="post-metadata">

**Author:** ![Kahuna](https://avatars.discourse-cdn.com/v4/letter/k/8491ac/32.png) [@Kahuna](https://forum.servoy.com/u/Kahuna)\
**Post date:** [May 28, 2009, 1:31pm UTC](https://forum.servoy.com/t/individual-sql-logins/10686/19 "2009-05-28T13:31:21Z")

</div>

> rgansevles:  
> Ian,
> 
> In 4.2 we have a new attribute in server definition that links one server to another (‘is a clone of’).  
> When an import in the main server has data structure changes, these will be applied in the ‘clone’ servers as well.
> 
> This setting is only used while importing solutions.
> 
> Rob

VERY Cool Rob - I’ll investigate! Thanks

---

<div class="post-metadata">

**Author:** ![pbakker](https://avatars.discourse-cdn.com/v4/letter/p/a4c791/32.png) [@pbakker](https://forum.servoy.com/u/pbakker)\
**Post date:** [May 28, 2009, 1:35pm UTC](https://forum.servoy.com/t/individual-sql-logins/10686/20 "2009-05-28T13:35:46Z")

</div>

> In a single connection model, does the “Table Filtering” feature of Servoy operate at the SQL Database level on an individual user basis, or is this filtering being done within the “Servoy” code, cache.

Tablefiltering is always session specific, so bound to the user

Paul

[Next page](https://forum.servoy.com/t/individual-sql-logins/10686.md?page=2)
