CREATE USER admin_dba
IDENTIFIED BY super_user
DEFAULT TABLESPACE dba_ts
TEMPORARY TABLESPACE temp_user_1
QUOTA UNLIMITED ON dba_ts
QUOTA 500K ON SYSTEM
PROFILE mega_user;
IDENTIFIED BY super_user
DEFAULT TABLESPACE dba_ts
TEMPORARY TABLESPACE temp_user_1
QUOTA UNLIMITED ON dba_ts
QUOTA 500K ON SYSTEM
PROFILE mega_user;
解决方案 »
- oracle security management
- system 能登陆em 但是sqlplus页面登录不了的,高手回复
- 請教各位達人
- 如何在B库验证A库的用户及密码?
- 请教大虾们!
- sqlldr 将txt 文档中的数据上传到oracle 数据库中出现的问题,请大家帮我解决一下,谢谢!
- Oracle SQL Developer 出现jtds.jdbc.Driver错误怎么解决?
- 一个sql的问题, 在不同的机器上就报错, 很奇怪
- 请问一个存储过程的写法
- 服务器限制端口了,只有80,1521开放,程序可以连接到ORALCE,但是我PL/DEV,却连接不了ORALCE,提示没有监听器。
- OracleManagementServer启动问题,求你帮帮我
- 请问oracle中如何实现分页显示查询的记录
TO patrick ;Grant system privilege to role:GRANT create session
TO enduser;Grant object privilege to role:GRANT select
ON john.emp
TO enduser;
defalut spacetable user
temporary tablespace temp
quota unlimited on users;grant connect to myuser;
授权:grant connect,resource,exp_full_database,imp_full_database TO 用户名;
connect system/manager
create user...
grant ... to ...
sql>conn /as sysdba
sql>create user test identified by test default tablespace users
temporary tablespace temp;
sql>grant connect,resource to test;
create user xia identified by xia;
grant create session to user xia;
grant connnect,resource to user xia;
grant dba to user xia;
grant create table to user xia;
grant drop tabl3e to user xia;revoke dba from user xia;
alter user xia default tablespace tablespacename;
identified by "口令" default tablespace "users"
account unlock;
grant你想要输入的授权