Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Facing problem with alter session set current_schema

412800Jul 7 2006 — edited Jul 7 2006

Dear All

We have a multiuser software with backend Oracle 9i and Front end Power Builder 7.0. In it we have all user tables in a single scema for eg. ABC , and all the users have Connect and Resource privilege , After user login , for any user we change the current schema to ABC with the following command -
alter session set current_schema = ABC , It is running fine with Oracle 9i, but when doing the same with Oracle10g it is not changing the current schema and not able to get tables at all. if we give DBA Privilege to user , then it change the current schema and running fine.
We can not give DBA permission to all user to make login in the software , otherwise it may be possible to damage db directly from backend.
Can anyone tell me , whats going wrong by me ...

Regrds
Shweta

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 4 2006

Added on Jul 7 2006

#general-database-discussions

12 comments

2,073 views