Progress Table Permissions

Yahoo Archive
1
Bill -



Please contact me off list if you still need the documents to set up
security for V8 so that I can forward them directly to you.



Contrary to comments on this thread, security can be setup on the database,
tables & fields so as to not conflict with the Vantage or Vista UI.



Calvin

calvin@...



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
hoomail4me
Sent: Friday, June 08, 2007 12:06 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Progress Table Permissions



I was looking for the same and just received what Epicor calls their
"Setting up ODBC for V800 (Progress Database)" KIT (file
v803odbcKit.rtf). This was not a KIT, just a document that describes
the basic ODBC setup and configuration. It did reference a SQL script
that was suppose to be in the KIT to make it easy to set the table
permissions for a user but it was not included and Epicor support says
that the instructions are in error - there isn't any script available.
By default, the mfgsys databases have permissions set for the
"sysprogress" user - wide open permissions. I would not want my
report writers to have wide open permissions to the databases through
ODBC. Setting up another user with reduced permissions is an absolute
must - READ only and no access to sensitive tables - payroll, etc..

Anyone have a script for the Vantage 8 schema? Without, it makes
setting permissions on the hundreds of tables very time consumming.

Thanks,

Bill

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Jason
Claggett" <jason@...> wrote:
>
> Experience has been, you really don't want to mess with changing the
> permissions on the database as it can wreak havoc on any and all custom
> reports, ODBC driver setup, etc. With that in mind, it can be done. Best
> thing to do is get the documentation straight from Epicor if you still
> want to do it.
>
>
>
> You should be able to control via domain/user authentication as well as
> through Vantage application.
>
>
>
> Thanks,
>
>
>
> Jason Claggett
>
> Microsoft Small Business Specialist
>
> MCP #3856159
>
> 2W Technologies, LLC
>
> 317.578.2393
>
> jason@...
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of sanfranc415
> Sent: Wednesday, June 06, 2007 6:36 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Progress Table Permissions
>
>
>
> I've noticed that by default all the tables and fields in progress give
> read/write access to "*" Is there a way to change this without
> manually going to each table and changing the permissions?
>
> Thanks,
>
> --TJ
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
2
I've noticed that by default all the tables and fields in progress give
read/write access to "*" Is there a way to change this without
manually going to each table and changing the permissions?

Thanks,

--TJ
3
Experience has been, you really don't want to mess with changing the
permissions on the database as it can wreak havoc on any and all custom
reports, ODBC driver setup, etc. With that in mind, it can be done. Best
thing to do is get the documentation straight from Epicor if you still
want to do it.



You should be able to control via domain/user authentication as well as
through Vantage application.



Thanks,



Jason Claggett

Microsoft Small Business Specialist

MCP #3856159

2W Technologies, LLC

317.578.2393

jason@...

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of sanfranc415
Sent: Wednesday, June 06, 2007 6:36 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Progress Table Permissions



I've noticed that by default all the tables and fields in progress give
read/write access to "*" Is there a way to change this without
manually going to each table and changing the permissions?

Thanks,

--TJ





[Non-text portions of this message have been removed]
4
I was looking for the same and just received what Epicor calls their
"Setting up ODBC for V800 (Progress Database)" KIT (file
v803odbcKit.rtf). This was not a KIT, just a document that describes
the basic ODBC setup and configuration. It did reference a SQL script
that was suppose to be in the KIT to make it easy to set the table
permissions for a user but it was not included and Epicor support says
that the instructions are in error - there isn't any script available.
By default, the mfgsys databases have permissions set for the
"sysprogress" user - wide open permissions. I would not want my
report writers to have wide open permissions to the databases through
ODBC. Setting up another user with reduced permissions is an absolute
must - READ only and no access to sensitive tables - payroll, etc..

Anyone have a script for the Vantage 8 schema? Without, it makes
setting permissions on the hundreds of tables very time consumming.

Thanks,

Bill



--- In vantage@yahoogroups.com, "Jason Claggett" <jason@...> wrote:
>
> Experience has been, you really don't want to mess with changing the
> permissions on the database as it can wreak havoc on any and all custom
> reports, ODBC driver setup, etc. With that in mind, it can be done. Best
> thing to do is get the documentation straight from Epicor if you still
> want to do it.
>
>
>
> You should be able to control via domain/user authentication as well as
> through Vantage application.
>
>
>
> Thanks,
>
>
>
> Jason Claggett
>
> Microsoft Small Business Specialist
>
> MCP #3856159
>
> 2W Technologies, LLC
>
> 317.578.2393
>
> jason@...
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of sanfranc415
> Sent: Wednesday, June 06, 2007 6:36 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Progress Table Permissions
>
>
>
> I've noticed that by default all the tables and fields in progress give
> read/write access to "*" Is there a way to change this without
> manually going to each table and changing the permissions?
>
> Thanks,
>
> --TJ
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
5
Bill -



Contrary to comments on this thread, security can be setup on the database,
tables & fields so as to not conflict with the Vantage or Vista UI without
difficulty. I don't know why people do this, but the sysprogress UID & PWD
should NEVER BE SHARED. Do you share your System Manager password? If you
are adding users, add a user and set their security respectively. Rule of
thumb: never share administrative passwords!



Please contact me off list if you still need the documents to set up
security for V8 so that I can forward them directly to you.



Calvin

calvin@...



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
hoomail4me
Sent: Friday, June 08, 2007 12:06 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Progress Table Permissions



I was looking for the same and just received what Epicor calls their
"Setting up ODBC for V800 (Progress Database)" KIT (file
v803odbcKit.rtf). This was not a KIT, just a document that describes
the basic ODBC setup and configuration. It did reference a SQL script
that was suppose to be in the KIT to make it easy to set the table
permissions for a user but it was not included and Epicor support says
that the instructions are in error - there isn't any script available.
By default, the mfgsys databases have permissions set for the
"sysprogress" user - wide open permissions. I would not want my
report writers to have wide open permissions to the databases through
ODBC. Setting up another user with reduced permissions is an absolute
must - READ only and no access to sensitive tables - payroll, etc..

Anyone have a script for the Vantage 8 schema? Without, it makes
setting permissions on the hundreds of tables very time consumming.

Thanks,

Bill

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Jason
Claggett" <jason@...> wrote:
>
> Experience has been, you really don't want to mess with changing the
> permissions on the database as it can wreak havoc on any and all custom
> reports, ODBC driver setup, etc. With that in mind, it can be done. Best
> thing to do is get the documentation straight from Epicor if you still
> want to do it.
>
>
>
> You should be able to control via domain/user authentication as well as
> through Vantage application.
>
>
>
> Thanks,
>
>
>
> Jason Claggett
>
> Microsoft Small Business Specialist
>
> MCP #3856159
>
> 2W Technologies, LLC
>
> 317.578.2393
>
> jason@...
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of sanfranc415
> Sent: Wednesday, June 06, 2007 6:36 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Progress Table Permissions
>
>
>
> I've noticed that by default all the tables and fields in progress give
> read/write access to "*" Is there a way to change this without
> manually going to each table and changing the permissions?
>
> Thanks,
>
> --TJ
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





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