Query Security

S

souris

I have an app to use query to download data from mainframe daily.
May I have use my user name and password in the query through ODBC?
If the query has my user name and password then the mainframe only knows I
logon, but not real user if other user run the query. Am I right?

If yes, is it possible to have dynamic user name and password in the query?

Any information is great appreciated.

Souris,
 
R

Rick Brandt

souris said:
I have an app to use query to download data from mainframe daily.
May I have use my user name and password in the query through ODBC?
If the query has my user name and password then the mainframe only
knows I logon, but not real user if other user run the query. Am I
right?
If yes, is it possible to have dynamic user name and password in the
query?
Any information is great appreciated.

Souris,
Click to expand...

It depends. Some ODBC drivers support saving the UserName and Password while
others don't. Of the ones that do this ability can be disabled on the server
should the db admin decide to do so.

One can always create or modify the query with code and apply the UserName and
Password, but that means embedding that data in the code (which is not a good
idea).

It's not clear from your post what behavior you're trying to achieve. Do you
want to let all users run a query with your authority or do you want to prevent
it?
 
S

souris

I develop the app, but I want to know who access the data and different
people have different rights.
If user may run my query then he may do what the rights I have.

Souris,
 
Top