ODBC security Blank Title 53307

Yahoo Archive
1
Is this set up in the ODBC data source configuration or in the
Enterprise Manager, since we're running Vantage 8.00 on SQL?

Also, what is your recommendation for getting up to speed on SQL
Server 2000, as it relates to Vantage? Would you recommend an
Epicor SQL class or an actual SQL Server 2000 course?

--- In vantage@yahoogroups.com, "Stephen Edginton" <stephene@...>
wrote:
>
> You can use the Grant statement such as :
>
>
>
> Gant Select On Pub.Part To odbcreader;
>
> Commit work;
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of acp2g99
> Sent: 25 November 2006 07:19
> To: vantage@yahoogroups.com
> Subject: [Vantage] ODBC security
>
>
>
> Does anyone know how to set security on the ODBC of a Vantage 8.0
SQL
> database so your users cannot write back to the database?
>
>
>
> [Non-text portions of this message have been removed]
>
2
Does anyone know how to set security on the ODBC of a Vantage 8.0 SQL
database so your users cannot write back to the database?
3
You can use the Grant statement such as :



Gant Select On Pub.Part To odbcreader;

Commit work;



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of acp2g99
Sent: 25 November 2006 07:19
To: vantage@yahoogroups.com
Subject: [Vantage] ODBC security



Does anyone know how to set security on the ODBC of a Vantage 8.0 SQL
database so your users cannot write back to the database?



[Non-text portions of this message have been removed]
4
>"commit work"<

I hate to ask dumb questions, but what is the difference between
"Commit;" and "Commit work;"?



Gerard M Wadman

Sr. Network Systems Engineer



Scandius BioMedical Inc.

11A Beaver Brook Road

Littleton, MA 01460



978/486-4088 x 124

978/486-4108 (fax)



http://www.scandius.com/





________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Stephen Edginton
Sent: Saturday, November 25, 2006 12:03 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] ODBC security



You can use the Grant statement such as :

Gant Select On Pub.Part To odbcreader;

Commit work;

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of acp2g99
Sent: 25 November 2006 07:19
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] ODBC security

Does anyone know how to set security on the ODBC of a Vantage 8.0 SQL
database so your users cannot write back to the database?

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





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