List ODBC permissions

That data is stored outside of the scope of Vantage. The only way I know to
get it is to create on ODBC program or use one of the third party products
to access the Progress tables. If you are using Progress 10.0b you might be
able to get it using SQL Explorer. I never tried but it should be possible.



_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Rojas, Joe
Sent: Friday, April 11, 2008 10:03 AM
To: vantage@yahoogroups.com
Subject: [Vantage] List ODBC permissions



Hello,

When I execute GRANT statement to allow users ODBC access to OpenEdge,
I'm assuming this is store is some type of permissions table.

Does anyone know of a way to list these permissions?

Joe Rojas

Information Technology Manager

Symmetry Medical New Bedford

P: 508.998.4575

C:508.838.4717

joe.rojas@symmetryn <mailto:joe.rojas%40symmetrynb.com> b.com
<mailto:joe.rojas@symmetryn <mailto:joe.rojas%40symmetrynb.com> b.com>

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





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



When I execute GRANT statement to allow users ODBC access to OpenEdge,
I'm assuming this is store is some type of permissions table.

Does anyone know of a way to list these permissions?



Joe Rojas

Information Technology Manager

Symmetry Medical New Bedford

P: 508.998.4575

C:508.838.4717

joe.rojas@... <mailto:joe.rojas@...>





[Non-text portions of this message have been removed]
> When I execute GRANT statement to allow users ODBC access to OpenEdge,
> I'm assuming this is store is some type of permissions table.
>
> Does anyone know of a way to list these permissions?

Generally this is stored in a system table in the database. I'm no OpenEdge
expert but I would guess _Systabauth.

Mark W.