Security Entry List

There is no way to purge this data. As with just about every field in Vantage, once it is used it is basically there forever with a few exceptions. If you could delete this record (i.e. user) it would cause many broken links to several other tables in Vantage. Never a good thing for a relational datbase.

Rick Lane
Intelligent Systems Integration, Inc.
600 Weber Drive
Wadsworth, OH 44281
PH: 330-335-5291 Fax: 330-335-7275



-----Original Message-----
From: Norm Watkins [mailto:nwatkins@...]
Sent: Tuesday, December 09, 2003 11:05 AM
To: Vantage@Yahoogroups. Com
Subject: [Vantage] Security Entry List


I just ran an RB security report I downloaded from the group, and find that
it lists "users" that have been deleted from vantage. Is there any way to
purge them from the database?

Using Vantage 5.0 patch 350

Norm Watkins
Engineering Mgr.
ELECPAC
847-639-2307



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
I just ran an RB security report I downloaded from the group, and find that
it lists "users" that have been deleted from vantage. Is there any way to
purge them from the database?

Using Vantage 5.0 patch 350

Norm Watkins
Engineering Mgr.
ELECPAC
847-639-2307
You could probably filter by "active" users only. I haven't been able to
delete them in the past.

Paul L.
-----Original Message-----
From: Norm Watkins [mailto:nwatkins@...]
Sent: Tuesday, December 09, 2003 10:05 AM
To: Vantage@Yahoogroups. Com
Subject: [Vantage] Security Entry List


I just ran an RB security report I downloaded from the group, and find
that
it lists "users" that have been deleted from vantage. Is there any way to
purge them from the database?

Using Vantage 5.0 patch 350

Norm Watkins
Engineering Mgr.
ELECPAC
847-639-2307


Yahoo! Groups Sponsor
ADVERTISEMENT




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]
Isn't dangerous to delete inactive customers? Some tables enter the user
name in the record (i.e. Order Header table enters the user ID of the person
entering the order).

Mario Aguirre
Lakin General

-----Original Message-----
From: Paul Lipham [mailto:pml@...]
Sent: Tuesday, December 09, 2003 10:23 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Security Entry List

You could probably filter by "active" users only. I haven't been able to
delete them in the past.

Paul L.
-----Original Message-----
From: Norm Watkins [mailto:nwatkins@...]
Sent: Tuesday, December 09, 2003 10:05 AM
To: Vantage@Yahoogroups. Com
Subject: [Vantage] Security Entry List


I just ran an RB security report I downloaded from the group, and find
that
it lists "users" that have been deleted from vantage. Is there any way to
purge them from the database?

Using Vantage 5.0 patch 350

Norm Watkins
Engineering Mgr.
ELECPAC
847-639-2307


Yahoo! Groups Sponsor
ADVERTISEMENT




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


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





Yahoo! Groups Sponsor


ADVERTISEMENT

<http://rd.yahoo.com/SIG=12cne8p94/M=267637.4116732.5333197.1261774/D=egroup
web/S=1705007183:HM/EXP=1071073366/A=1853618/R=0/*http:/www.netflix.com/Defa
ult?mqso=60178338&partid=4116732> click here


<http://us.adserver.yahoo.com/l?M=267637.4116732.5333197.1261774/D=egroupmai
l/S=:HM/A=1853618/rand=679394613>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.


[Non-text portions of this message have been removed]
Isn't dangerous to delete inactive customers? Some tables enter the user
name in the record (i.e. Order Header table enters the user ID of the person
entering the order).

Mario Aguirre
Lakin General

-----Original Message-----
From: Paul Lipham [mailto:pml@...]
Sent: Tuesday, December 09, 2003 10:23 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Security Entry List

You could probably filter by "active" users only. I haven't been able to
delete them in the past.

Paul L.
-----Original Message-----
From: Norm Watkins [mailto:nwatkins@...]
Sent: Tuesday, December 09, 2003 10:05 AM
To: Vantage@Yahoogroups. Com
Subject: [Vantage] Security Entry List


I just ran an RB security report I downloaded from the group, and find
that
it lists "users" that have been deleted from vantage. Is there any way to
purge them from the database?

Using Vantage 5.0 patch 350

Norm Watkins
Engineering Mgr.
ELECPAC
847-639-2307


Yahoo! Groups Sponsor
ADVERTISEMENT




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


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





Yahoo! Groups Sponsor


ADVERTISEMENT

<http://rd.yahoo.com/SIG=12cne8p94/M=267637.4116732.5333197.1261774/D=egroup
web/S=1705007183:HM/EXP=1071073366/A=1853618/R=0/*http:/www.netflix.com/Defa
ult?mqso=60178338&partid=4116732> click here


<http://us.adserver.yahoo.com/l?M=267637.4116732.5333197.1261774/D=egroupmai
l/S=:HM/A=1853618/rand=679394613>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.


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