如题,oracle10g 版本10.2.0 数据库都是默认安装的,别的地方没有修改。
建立用户语句如下
create tablespace demo datafile 'D:\oracle\product\10.2.0\oradata\orcl\demo.dbf' size 100m autoextend on next 10m;create user demo identified by demo default tablespace demo ;grant dba to demo;grant all on dual to appsys with grant option;
为什么建立以后,PLSQL我只能用demo/sysdba 登陆。而normal 登陆不了啊,提示如标题高手指教
alter user demo account unlock ;这样我也试了,不管事啊。
建立用户语句如下
create tablespace demo datafile 'D:\oracle\product\10.2.0\oradata\orcl\demo.dbf' size 100m autoextend on next 10m;create user demo identified by demo default tablespace demo ;grant dba to demo;grant all on dual to appsys with grant option;
为什么建立以后,PLSQL我只能用demo/sysdba 登陆。而normal 登陆不了啊,提示如标题高手指教
alter user demo account unlock ;这样我也试了,不管事啊。
问题语句如下 -------------
-- Create the user
create user ITOM
default tablespace ITOM
temporary tablespace TEMP
profile DEFAULT;
-- Grant/Revoke object privileges
grant select, insert, update, delete, references, alter, index on DUAL to ITOM with grant option;
-- Grant/Revoke role privileges
grant connect to ITOM with admin option;
grant resource to ITOM with admin option;
-- Grant/Revoke system privileges
grant unlimited tablespace to ITOM with admin option;上边是我用plsql建立用户 itom 的语句,用sysdba身份登录。能行,但是用normal 提示 ora-01017 invalid username/password;logon denied感谢各位帮忙,现问题已解决。散分。。-- Create the user
create user ITOM1
default tablespace ITOM1
temporary tablespace TEMP
profile DEFAULT;
-- Grant/Revoke role privileges
grant connect to ITOM1;
grant resource to ITOM1;
-- Grant/Revoke system privileges
grant create any view to ITOM1;
grant create materialized view to ITOM1;
grant select any dictionary to ITOM1;
grant unlimited tablespace to ITOM1;一上语句测试通过,个人估计是
grant connect to ITOM with admin option; with admin option 造成的