Setting CURRENT_SCHEMA externally
From: <ritu_at_my-deja.com>
Date: 2000/05/04
Message-ID: <8esmn1$pj3$1_at_nnrp1.deja.com>#1/1
Date: 2000/05/04
Message-ID: <8esmn1$pj3$1_at_nnrp1.deja.com>#1/1
Is it possible to set a default Schema for a users?
For example, how do I assign the user BATCH, to schema OWNER etc.
I am aware of the following:
I can open a session with the BATCH user and then issue the following command:
ALTER SESSION SET CURRENT_SCHEMA = OWNER My problem is that I want to be able to set this as a system default externally (for example, using Security Manager or Schema Manager).
Please help.
Sincerely,
Ritu
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Thu May 04 2000 - 00:00:00 CEST