OT: was Deleting users is Vantage 6.10

I just caught up on weeks worth of Vantage post e-mails and got a
good laugh from this. Very creative - Thanks!

--- In vantage@yahoogroups.com, "Mark Wonsil" <mark_wonsil@...>
wrote:
>
> > It's like "Hotel California" old users can check out (be
disabled) but they
> > can never leave (be deleted).
>
> Since I'm killing time in the Orthodontist's office, I've expanded
on Todd's
> very, very funny line and finished the whole tune:
>
> Hotel Vantage-Vista
>
> On Gore's superhighway, cooling fans in my ear
> Warm smell of disc-drives, rising up through the air
> Up ahead in the rack-space, saw some flickering lights
> My head grew heavy and my sight grew dim
> Must stop coding for the night
>
> There they stood in the doorway;
> I heard the Controller yell
> And I was thinking to myself,
> 'This could be a dot Net or DLL Hell'
> Then they fired up the client and they showed me way.
> They said "Those arn't bugs up there...
> ....we designed it that way."
>
> Welcome to the Hotel Vantage-Vista
> Such a lovely screen (Such a lovely screen)
> Costs lots of green.
> Need plenty of RAM at the Hotel Vantage-Vista
> In about a year (In about a year)
> We'll have that feature here.
>
> The code's really-twisted, it sometimes abends
> They got some pretty tools - they call BPMs
> They program in C-Sharp, sweet Redmond sweat.
> Some code they remember, some code they forget
>
> I asked the System Manager,
> 'Please run this on Wine'
> He said, 'We haven't had stability here since Windows of 99'
> And still that process is calling from far away,
> A Web Service in the middle of the night
> ....we started earlier that day.
>
> Welcome to the Hotel Vantage-Vista
> Such a lovely Grid (Such a lovely Grid)
> Why's that columns hid?
> We're livin' it up at the Hotel Vantage-Vista
> What a nice surprise (what a nice surprise)
> My session's still alive...
>
> Mirrors of the disc drives,
> Version eight is on ICE
> I think 'We're just prisoners here, of our own advice'
> With the Progress Explorer,
> They prepared to delete
> They stab it with their Escape keys,
> But the process did not decease.
>
> Last thing I remember,
> the record was modified before
> Had to restore the user back
> To the way she was before
> 'Refresh,' said support man,
> 'We're trained to defeat.
> You can add as much as you like,
> But you can never delete!'
>
HAs anyone worked up a utility for cleaning up inactive user rights so
they can cleanly be deleted or conversely cleaning up the security
table for users that no longer exist
Vantage is forever. At least that's what we were told. With all the places the UserID is stored (change logs, memos, notes, various transactions, etc...) it would be impossible ot chase them all down and delete the records...which could in turn leave inconsistant references elsewhere and unbalance the whole database. Best case might be to created a user called "Deleted" and change all teh references to this new UserID then delete the user form the user table but this would still carry a lot of risk as well as losing track of who did what in a historical sense.

It's like "Hotel California" old users can check out (be disabled) but they can never leave (be deleted).

-Todd C.

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of dramirez2
Sent: Thursday, April 10, 2008 2:08 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Deleting users is Vantage 6.10


HAs anyone worked up a utility for cleaning up inactive user rights so
they can cleanly be deleted or conversely cleaning up the security
table for users that no longer exist





[Non-text portions of this message have been removed]
That's true but what I am really after is removing them from groups and
the security table so I can generate reports and not have to be forever
editing them to remove the inactive users or in case of deletion the
users that are no longer there



Daniel J. Ramirez

IT Manager

BTL Machine, Inc

1168 Sherborn st.

Corona, CA 92879

Ph. 951-808-9929

Eamil dramirez@...



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Caughey
Sent: Thursday, April 10, 2008 12:16 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Deleting users is Vantage 6.10



Vantage is forever. At least that's what we were told. With all the
places the UserID is stored (change logs, memos, notes, various
transactions, etc...) it would be impossible ot chase them all down and
delete the records...which could in turn leave inconsistant references
elsewhere and unbalance the whole database. Best case might be to
created a user called "Deleted" and change all teh references to this
new UserID then delete the user form the user table but this would still
carry a lot of risk as well as losing track of who did what in a
historical sense.

It's like "Hotel California" old users can check out (be disabled) but
they can never leave (be deleted).

-Todd C.

________________________________
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of dramirez2
Sent: Thursday, April 10, 2008 2:08 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Deleting users is Vantage 6.10

HAs anyone worked up a utility for cleaning up inactive user rights so
they can cleanly be deleted or conversely cleaning up the security
table for users that no longer exist

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
Ahhh! Cleaning out the Security Settings not the user. Which reports are you running this matters for? When I disable a formaer employee I just leave all their groups assignments in place although I could remove them at that time. But is is very handy to leave them so I can see what to set their replacement with. Then again we are pretty small with no more than 50 users sharing 33 full licenses (and 14 DC). Sorry, it's never become a big enough issue to be worth automating (if possible).
-Todd C.

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Daniel J. Ramirez
Sent: Thursday, April 10, 2008 2:43 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Deleting users is Vantage 6.10


That's true but what I am really after is removing them from groups and
the security table so I can generate reports and not have to be forever
editing them to remove the inactive users or in case of deletion the
users that are no longer there

Daniel J. Ramirez

IT Manager

BTL Machine, Inc

1168 Sherborn st.

Corona, CA 92879

Ph. 951-808-9929

Eamil dramirez@...<mailto:dramirez%40btlmachine.com>

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of Todd Caughey
Sent: Thursday, April 10, 2008 12:16 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Deleting users is Vantage 6.10

Vantage is forever. At least that's what we were told. With all the
places the UserID is stored (change logs, memos, notes, various
transactions, etc...) it would be impossible ot chase them all down and
delete the records...which could in turn leave inconsistant references
elsewhere and unbalance the whole database. Best case might be to
created a user called "Deleted" and change all teh references to this
new UserID then delete the user form the user table but this would still
carry a lot of risk as well as losing track of who did what in a
historical sense.

It's like "Hotel California" old users can check out (be disabled) but
they can never leave (be deleted).

-Todd C.

________________________________
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ] On
Behalf Of dramirez2
Sent: Thursday, April 10, 2008 2:08 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Deleting users is Vantage 6.10

HAs anyone worked up a utility for cleaning up inactive user rights so
they can cleanly be deleted or conversely cleaning up the security
table for users that no longer exist

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
Daniel,
Again, not much help after the fact, but it might be worth saying for
anyone that has not made it that far down the road.
This is one of the best reasons for using groups. Even if your groups
are by job title.
That way the user id never finds it's way into the security profile and
when someone new enters the position, you just make them part of the
group and remove the old user from it and the job is done.
Hope this helps someone. (I am still in the process of getting users
into groups and still finding user ids in the security setup 3 years later).
Aaron Hoyt
Vantage Plastics


Daniel J. Ramirez wrote:
>
> That's true but what I am really after is removing them from groups and
> the security table so I can generate reports and not have to be forever
> editing them to remove the inactive users or in case of deletion the
> users that are no longer there
>
> Daniel J. Ramirez
>
> IT Manager
>
> BTL Machine, Inc
>
> 1168 Sherborn st.
>
> Corona, CA 92879
>
> Ph. 951-808-9929
>
> Eamil dramirez@... <mailto:dramirez%40btlmachine.com>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>] On
> Behalf
> Of Todd Caughey
> Sent: Thursday, April 10, 2008 12:16 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] Deleting users is Vantage 6.10
>
> Vantage is forever. At least that's what we were told. With all the
> places the UserID is stored (change logs, memos, notes, various
> transactions, etc...) it would be impossible ot chase them all down and
> delete the records...which could in turn leave inconsistant references
> elsewhere and unbalance the whole database. Best case might be to
> created a user called "Deleted" and change all teh references to this
> new UserID then delete the user form the user table but this would still
> carry a lot of risk as well as losing track of who did what in a
> historical sense.
>
> It's like "Hotel California" old users can check out (be disabled) but
> they can never leave (be deleted).
>
> -Todd C.
>
> ________________________________
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ] On
> Behalf Of dramirez2
> Sent: Thursday, April 10, 2008 2:08 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Deleting users is Vantage 6.10
>
> HAs anyone worked up a utility for cleaning up inactive user rights so
> they can cleanly be deleted or conversely cleaning up the security
> table for users that no longer exist
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>


[Non-text portions of this message have been removed]
Oh trust me I too believe in groups. Unfortunately I am only here on
this job for three weeks and am in the process of cleaning up all the
sins of the previous folks.

I will be transitioning to group security real soon.



Daniel J. Ramirez

IT Manager

BTL Machine, Inc

1168 Sherborn st.

Corona, CA 92879

Ph. 951-808-9929

Eamil dramirez@...



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Aaron Hoyt
Sent: Thursday, April 10, 2008 1:04 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Deleting users is Vantage 6.10



Daniel,
Again, not much help after the fact, but it might be worth saying for
anyone that has not made it that far down the road.
This is one of the best reasons for using groups. Even if your groups
are by job title.
That way the user id never finds it's way into the security profile and
when someone new enters the position, you just make them part of the
group and remove the old user from it and the job is done.
Hope this helps someone. (I am still in the process of getting users
into groups and still finding user ids in the security setup 3 years
later).
Aaron Hoyt
Vantage Plastics

Daniel J. Ramirez wrote:
>
> That's true but what I am really after is removing them from groups
and
> the security table so I can generate reports and not have to be
forever
> editing them to remove the inactive users or in case of deletion the
> users that are no longer there
>
> Daniel J. Ramirez
>
> IT Manager
>
> BTL Machine, Inc
>
> 1168 Sherborn st.
>
> Corona, CA 92879
>
> Ph. 951-808-9929
>
> Eamil dramirez@... <mailto:dramirez%40btlmachine.com>
<mailto:dramirez%40btlmachine.com>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>] On
> Behalf
> Of Todd Caughey
> Sent: Thursday, April 10, 2008 12:16 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] Deleting users is Vantage 6.10
>
> Vantage is forever. At least that's what we were told. With all the
> places the UserID is stored (change logs, memos, notes, various
> transactions, etc...) it would be impossible ot chase them all down
and
> delete the records...which could in turn leave inconsistant references
> elsewhere and unbalance the whole database. Best case might be to
> created a user called "Deleted" and change all teh references to this
> new UserID then delete the user form the user table but this would
still
> carry a lot of risk as well as losing track of who did what in a
> historical sense.
>
> It's like "Hotel California" old users can check out (be disabled) but
> they can never leave (be deleted).
>
> -Todd C.
>
> ________________________________
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ] On
> Behalf Of dramirez2
> Sent: Thursday, April 10, 2008 2:08 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Deleting users is Vantage 6.10
>
> HAs anyone worked up a utility for cleaning up inactive user rights so
> they can cleanly be deleted or conversely cleaning up the security
> table for users that no longer exist
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
I've been in my current position for almost a year, and the sins of
the previous folk as related to Vantage are WAY less painful than the
sins I've found committed around the rest of the network! :)

--- In vantage@yahoogroups.com, "Daniel J. Ramirez" <dramirez@...>
wrote:
>
> Oh trust me I too believe in groups. Unfortunately I am only here on
> this job for three weeks and am in the process of cleaning up all
the
> sins of the previous folks.
>
> I will be transitioning to group security real soon.
>
>
>
> Daniel J. Ramirez
>
> IT Manager
>
> BTL Machine, Inc
>
> 1168 Sherborn st.
>
> Corona, CA 92879
>
> Ph. 951-808-9929
>
> Eamil dramirez@...
> It's like "Hotel California" old users can check out (be disabled) but they
> can never leave (be deleted).

Since I'm killing time in the Orthodontist's office, I've expanded on Todd's
very, very funny line and finished the whole tune:

Hotel Vantage-Vista

On Gore's superhighway, cooling fans in my ear
Warm smell of disc-drives, rising up through the air
Up ahead in the rack-space, saw some flickering lights
My head grew heavy and my sight grew dim
Must stop coding for the night

There they stood in the doorway;
I heard the Controller yell
And I was thinking to myself,
'This could be a dot Net or DLL Hell'
Then they fired up the client and they showed me way.
They said "Those arn't bugs up there...
....we designed it that way."

Welcome to the Hotel Vantage-Vista
Such a lovely screen (Such a lovely screen)
Costs lots of green.
Need plenty of RAM at the Hotel Vantage-Vista
In about a year (In about a year)
We'll have that feature here.

The code's really-twisted, it sometimes abends
They got some pretty tools - they call BPMs
They program in C-Sharp, sweet Redmond sweat.
Some code they remember, some code they forget

I asked the System Manager,
'Please run this on Wine'
He said, 'We haven't had stability here since Windows of 99'
And still that process is calling from far away,
A Web Service in the middle of the night
....we started earlier that day.

Welcome to the Hotel Vantage-Vista
Such a lovely Grid (Such a lovely Grid)
Why's that columns hid?
We're livin' it up at the Hotel Vantage-Vista
What a nice surprise (what a nice surprise)
My session's still alive...

Mirrors of the disc drives,
Version eight is on ICE
I think 'We're just prisoners here, of our own advice'
With the Progress Explorer,
They prepared to delete
They stab it with their Escape keys,
But the process did not decease.

Last thing I remember,
the record was modified before
Had to restore the user back
To the way she was before
'Refresh,' said support man,
'We're trained to defeat.
You can add as much as you like,
But you can never delete!'
Will this be showcased at Perspectives this year?

BTW: How much laughing gas is that Orthodonist dishing out?


--- In vantage@yahoogroups.com, "Mark Wonsil" <mark_wonsil@...>
wrote:
>
> > It's like "Hotel California" old users can check out (be
disabled) but they
> > can never leave (be deleted).
>
> Since I'm killing time in the Orthodontist's office, I've expanded
on Todd's
> very, very funny line and finished the whole tune:
>
> Hotel Vantage-Vista
>
> On Gore's superhighway, cooling fans in my ear
> Warm smell of disc-drives, rising up through the air
> Up ahead in the rack-space, saw some flickering lights
> My head grew heavy and my sight grew dim
> Must stop coding for the night
>
> There they stood in the doorway;
> I heard the Controller yell
> And I was thinking to myself,
> 'This could be a dot Net or DLL Hell'
> Then they fired up the client and they showed me way.
> They said "Those arn't bugs up there...
> ....we designed it that way."
>
> Welcome to the Hotel Vantage-Vista
> Such a lovely screen (Such a lovely screen)
> Costs lots of green.
> Need plenty of RAM at the Hotel Vantage-Vista
> In about a year (In about a year)
> We'll have that feature here.
>
> The code's really-twisted, it sometimes abends
> They got some pretty tools - they call BPMs
> They program in C-Sharp, sweet Redmond sweat.
> Some code they remember, some code they forget
>
> I asked the System Manager,
> 'Please run this on Wine'
> He said, 'We haven't had stability here since Windows of 99'
> And still that process is calling from far away,
> A Web Service in the middle of the night
> ....we started earlier that day.
>
> Welcome to the Hotel Vantage-Vista
> Such a lovely Grid (Such a lovely Grid)
> Why's that columns hid?
> We're livin' it up at the Hotel Vantage-Vista
> What a nice surprise (what a nice surprise)
> My session's still alive...
>
> Mirrors of the disc drives,
> Version eight is on ICE
> I think 'We're just prisoners here, of our own advice'
> With the Progress Explorer,
> They prepared to delete
> They stab it with their Escape keys,
> But the process did not decease.
>
> Last thing I remember,
> the record was modified before
> Had to restore the user back
> To the way she was before
> 'Refresh,' said support man,
> 'We're trained to defeat.
> You can add as much as you like,
> But you can never delete!'
>