更新时间:2022-09-18 19:43:07
C:\Documents and Settings\ssy>sqlplus sys/密码@数据库名称 as sysdba
SQL*Plus: Release 9.2.0.1.0 - Production on 星期一 3月 17 18:01:41 2008 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. 连接到: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production
|
C:\Documents and Settings\ssy>sqlplus /nolog
SQL*Plus: Release 9.2.0.1.0 - Production on 星期一 3月 17 17:59:08 2008 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> conn sys/密码@数据库名称 as sysdba 已连接。
create user cmsuser identified by "cmsuser";
SQL> create user uumcuser identified by "password";
User created.
SQL> grant connect,dba to uumcuser;
Grant succeeded.
SQL> grant exp_full_database,imp_full_database,resource,create any sequence to cmsuser;
Grant succeeded.
SQL> grant create any trigger,create any view,create table,drop any view to uumcuser;
Grant succeeded.
SQL> grant exp_full_database,imp_full_database,resource,create any sequence to uumcuser;
Grant succeeded.
|