cuser.sql

来自「orale培训教材包括了所有的sql说明和实例」· SQL 代码 · 共 13 行

set verify off
set echo off
accept username char prompt 'input username:'
accept password char prompt 'input password:' HIDE
create user &username identified by &password;
grant connect to &username;
grant resource to &username;
set echo on
set verify on
connect &username/&password;
exit