Re: DBA? - copying users to another instance - DBA?
From: Chris Dipple <chris_at_chin.demon.co.uk>
Date: 1996/10/09
Message-ID: <kvxqpAAo65WyEwXy_at_chin.demon.co.uk>#1/1
Date: 1996/10/09
Message-ID: <kvxqpAAo65WyEwXy_at_chin.demon.co.uk>#1/1
In article <32595328.19B4_at_mindlink.bc.ca>, David Ng
<david_ng_at_mindlink.bc.ca> writes
>komix Hui wrote:
>>
>> Robert Cordingley wrote:
>>
>> >
>> > You can do CREATE USER username IDENTIFIED BY VALUES '<encoded password
>> > string here>';
>> >
>>
>> I cannot find such syntax of 'create user' statement as above in 'SQL
>> Reference' from Oracle.
>> Could you give some indication which hardware/software platform you are
>> using?
>>
>> Thank you.
>I believe he means 'GRANT CONNECT to USER UserName identfied by
>Password'.
>
>David Ng
No he doesn't, this is useful but undocumented syntax.
-- Chris Dipple, Production DBA, Royal Bank of ScotlandReceived on Wed Oct 09 1996 - 00:00:00 CEST