|
-
Originally posted by jmodic
You have two options (apart the one mentioned by jovery):
- create PUBLIC synonyms for that tables (so you'll have only 250 synonyms, not 2500)
- allow your users to perform the following : ALTER SESSION SET CURRENT_SCHEMA = USER1;
does that then allow users to change data in tables in that schema?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote