Business Activity Query Security Issue

Yahoo Archive
1
Correct
2
Hi Group,
I am wondering how you guys handle security access for the Business
Activity Query?? It seems to me that Epicor had the foresight to
allow us to limit rights as far as a user 'Editing' a query, but we
can't seem to limit 'Add' rights. We need users to be able to see the
query window and be able to run queries but NOT be able to Add new
ones!! The reason for this lies in the presence of the 'Query Wizard'
inside this tool. While a nice, easy way to present users with a way
of creating queries, this Wizard presents users with a list of tables
to choose from. And one of those tables is "EmpBasic" which if you
are doing costing, means that employee wages are in this table. So
anyone who has rights to BAQ can export this table and see everyones
wages!
So at this time, we have taken rights to the Business Activity Query
away from everyone but the Security Managers. So we've lost a lot of
functionality and now we, as Security Managers, have to run queries
for everone. This is a HUGE pain!

Input? Ideas?
Thanks,
Joey
3
If you mark your queries as shared, the users can add the queries to
their dashboard. Right click in the left pane and select item
properties. Add a dashboard query. When you select the spyglass for
the file, it will list all the BAQs that are shared.

Butch

________________________________

From: joeyloken [mailto:joeyloken@...]
Sent: Wednesday, August 11, 2004 8:46 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Business Activity Query Security Issue


Hi Group,
I am wondering how you guys handle security access for the Business
Activity Query?? It seems to me that Epicor had the foresight to
allow us to limit rights as far as a user 'Editing' a query, but we
can't seem to limit 'Add' rights. We need users to be able to see the
query window and be able to run queries but NOT be able to Add new
ones!! The reason for this lies in the presence of the 'Query Wizard'
inside this tool. While a nice, easy way to present users with a way
of creating queries, this Wizard presents users with a list of tables
to choose from. And one of those tables is "EmpBasic" which if you
are doing costing, means that employee wages are in this table. So
anyone who has rights to BAQ can export this table and see everyones
wages!
So at this time, we have taken rights to the Business Activity Query
away from everyone but the Security Managers. So we've lost a lot of
functionality and now we, as Security Managers, have to run queries
for everone. This is a HUGE pain!

Input? Ideas?
Thanks,
Joey



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



Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129ipg36q/M=298184.5285298.6392945.3001176/
D=groups/S=1705007183:HM/EXP=1092325596/A=2164330/R=0/SIG=11eamf8g4/*htt
p://www.netflix.com/Default?mqso=60183350>

<http://us.adserver.yahoo.com/l?M=298184.5285298.6392945.3001176/D=group
s/S=:HM/A=2164330/rand=564777181>

________________________________

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

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




[Non-text portions of this message have been removed]
4
We did think of this and although you can view the queries from the
Dashboard, you can't do anything else with them there. We NEED the
export to Excel and that's why we use the BAQ.
Thanks
5
Try a right click when you are viewing the query. Export is an option
(at least in 6.1). This brings up the export window allowing you to
choose the best format for the export and the location.
Hope this helps.
Aaron Hoyt
Hittite Microwave

-----Original Message-----
From: joeyloken [mailto:joeyloken@...]
Sent: Wednesday, August 11, 2004 12:09 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Business Activity Query Security Issue


We did think of this and although you can view the queries from
the
Dashboard, you can't do anything else with them there. We NEED
the
export to Excel and that's why we use the BAQ.
Thanks






[Non-text portions of this message have been removed]
6
If you need to export the data, another option would be to use an ODBC
application like Access which will allow you to present, manipulate, or
export the data to Excel automatically.

________________________________

From: joeyloken [mailto:joeyloken@...]
Sent: Wednesday, August 11, 2004 9:09 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Business Activity Query Security Issue


We did think of this and although you can view the queries from the
Dashboard, you can't do anything else with them there. We NEED the
export to Excel and that's why we use the BAQ.
Thanks





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



Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129tc5pd6/M=298184.5285298.6392945.3001176/
D=groups/S=1705007183:HM/EXP=1092326986/A=2164330/R=0/SIG=11eamf8g4/*htt
p://www.netflix.com/Default?mqso=60183350>

<http://us.adserver.yahoo.com/l?M=298184.5285298.6392945.3001176/D=group
s/S=:HM/A=2164330/rand=592846944>

________________________________

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

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




[Non-text portions of this message have been removed]
7
We are on 6.0, and unfortunately, do not have 'Export' as an
available option when right-clicking the Dashboard.
We are using another Access application that I have created through
ODBC to get some much needed info out of Vantage and, if it's the
only way, I am able to create another MS Access application capable
of doing what this export does ...... but it seems bizarre to me that
I would have to go to those lengths when the BAQ is right there in
front of us! If only Epicor had built in the ability to limit rights
for 'ADD'! This seems like a huge oversight to me! Does anyone else
believe that you can't give users total access to BAQ and live to
tell the story?? If I let my users have BAQ, eventually they will
figure out that they can see all this EmpBasic salary info. Talk
about stuff hitting the fan if that happened!!
8
I only have been on Vantage 6.1 so don't know when they added the
feature, but just to verify we're right clicking in the same spot, you
run the query and then right click the results to get the export option.


________________________________

From: joeyloken [mailto:joeyloken@...]
Sent: Wednesday, August 11, 2004 10:21 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Business Activity Query Security Issue


We are on 6.0, and unfortunately, do not have 'Export' as an
available option when right-clicking the Dashboard.
We are using another Access application that I have created through
ODBC to get some much needed info out of Vantage and, if it's the
only way, I am able to create another MS Access application capable
of doing what this export does ...... but it seems bizarre to me that
I would have to go to those lengths when the BAQ is right there in
front of us! If only Epicor had built in the ability to limit rights
for 'ADD'! This seems like a huge oversight to me! Does anyone else
believe that you can't give users total access to BAQ and live to
tell the story?? If I let my users have BAQ, eventually they will
figure out that they can see all this EmpBasic salary info. Talk
about stuff hitting the fan if that happened!!



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



Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129m9cikg/M=298184.5285298.6392945.3001176/
D=groups/S=1705007183:HM/EXP=1092331344/A=2164330/R=0/SIG=11eamf8g4/*htt
p://www.netflix.com/Default?mqso=60183350>

<http://us.adserver.yahoo.com/l?M=298184.5285298.6392945.3001176/D=group
s/S=:HM/A=2164330/rand=242314562>

________________________________

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

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




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