hi..
Iam new to DBA in Oracle 8.1.7. I have a UserA who has created 30 tables in database DB1.Now i need to create UserB
in the same database and can access all those tables created by UserA...
The problem is UserB will be accessing those tables thru some Front end Application thru ODBC connection...so his ODBC connection userid and password are "UserB/password".
This application is not recognizing those tables created by UserA., because UserB will be accessing those tables thru UserA schema...
any once can help me ?...What is the best way i can tackle this situation.
Also how do i give UserB access to all tables created by UserA in 1 sql statement ?..
any help is appreciated...
Iam new to DBA in Oracle 8.1.7. I have a UserA who has created 30 tables in database DB1.Now i need to create UserB
in the same database and can access all those tables created by UserA...
The problem is UserB will be accessing those tables thru some Front end Application thru ODBC connection...so his ODBC connection userid and password are "UserB/password".
This application is not recognizing those tables created by UserA., because UserB will be accessing those tables thru UserA schema...
any once can help me ?...What is the best way i can tackle this situation.
Also how do i give UserB access to all tables created by UserA in 1 sql statement ?..
any help is appreciated...