DB Line - Access data into DEV DB from PROD DB
I have a READ access request on two tables in production that needs to be queried from the DEV DB
For example:
A user - jsmith in DEV DB need access to couple of the table in PROD DB. T
To accomplish this, I have taken the following steps:
1. Created a public database link
2. created the user(jsmith) in both databases with same password.
3. in Production, I granted select access to two tables to jsmith and now he can query these tables from DEV DB.
My question: is there a way to accomplish the same but without synching the password in both databases?
For example:
A user - jsmith in DEV DB need access to couple of the table in PROD DB. T
To accomplish this, I have taken the following steps:
1. Created a public database link
2. created the user(jsmith) in both databases with same password.
3. in Production, I granted select access to two tables to jsmith and now he can query these tables from DEV DB.
My question: is there a way to accomplish the same but without synching the password in both databases?
0