-- Oracle create user.sql
------------------------创建用户----------------------
create user 20131026 identified by 20131026
default tablespace ring
temporary tablespace temp
/
------------------------授权用户----------------------
grant connect, resource, create any table, drop any table, create sequence,
alter any trigger, create any trigger, drop any trigger,
alter any type, create any type, drop any type,
create any view, drop any view,
create procedure, imp_full_database, exp_full_database,
create any directory, debug connect session,
create session to 20131026
/
grant execute on dbms_lock to 20131026
/
grant execute on dbms_job to 20131026
/
grant create job to 20131026
/
grant select on v_$session to 20131026
/
分享到:
相关推荐
详解oracle用户创建(create user)(上) 转载 http://blog.itpub.net/26110315/viewspace-715882/ 用户能访问数据库前必须要有获得相应授权的账号,oracle中创建一个用户并为其分配密码很简单,但是在创建用户的同时...
tempfile 'D:\oracle\oradata\Oracle9i\user_temp.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local; /*第2步:创建数据表空间 */ create tablespace test_data ...
sql>create user wwuser identified by wwuser default tablespace wwspace temporary tablespace temp 位置:D:\wwOracle\wwspace.dbf 用户名: wwuser 密码: wwuser 临时表:temp 3、创建角色 ...
CREATE USER 用户名 IDENTIFIED BY 用户名 DEFAULT TABLESPACE 用户名 TEMPORARY TABLESPACE temp; 为用户赋权限执行: GRANT CREATE SESSION,CREATE TABLE,CREATE VIEW,CREATE SEQUENCE,UNLIMITED TABLESPACE TO...
create or replace procedure test_msg(i_user in varchar2, o_msg out varchar2) is begin o_msg := i_user ||', Good Morning!'; end; 然后,开始在Python命令行中进行存储过程调用。 import cx_Oracle as cx ...
概述:在oracle中要创建一个新的用户使用create user语句,一般是具有dba(数据库管理员)的权限才能使用。 create user 用户名 identified by 密码; (oracle有个毛病,密码必须以字母开头,如果以字母开头,它不会...
Create user <user> identified by Alter user <user> default tablespace Alter user <user> quota <size> on Alter user <user> account lock|unlock Alter user <user> identified by Alter user <user...
CREATE USER ELWY IDENTIFIED BY "ELWY" DEFAULT TABLESPACE ELWY_DATA TEMPORARY TABLESPACE ELWY_TEMP; -- 用户授权 GRANT CONNECT,RESOURCE TO ELWY; GRANT UNLIMITED TABLESPACE TO ELWY;
create table 表名 (列说明列表); 为基表增加新列命令如下: ALTER TABLE 表名 ADD (列说明列表) 例:为test表增加一列Age,用来存放年龄 sql>alter table test add (Age number(3)); 修改基表列定义...
CREATE USER c##scott IDENTIFIED BY tiger; 2.为用户授权 GRANT CONNECT,RESOURCE,UNLIMITED TABLESPACE TO c##scott CONTAINER=ALL; 3、设置用户使用的表空间 ALTER USER c##scott DEFAULT TABLESPACE USERS; ...
Create a dir inside plugin dir called oracle. To make it easier you could copy mysql dir to oracle and remove the mysql-connector and prestodb-mysql jars. Finally put the prestodb-oracle in plugin/...
先把要安装的初始数据文件导出为initial.dmp,然后在客户计算上安装好Oracle,接着执行批处理文件impInitialData.bat(与该批处理文件同一目录还有createuser.sql,initial.dmp两个文件)。 大致的方法就是这样,可以再...
Correct user-induced errors with Oracle Flashback Product clone and standby databases on local or remote servers Use Oracle Real Application Clusters and synch and split technology For a complete ...
第四,GRANT CREATE USER,DROP USER,ALTER USER ,CREATE ANY VIEW , DROP ANY VIEW,EXP_FULL_DATABASE,IMP_FULL_DATABASE, DBA,CONNECT,RESOURCE,CREATE SESSION TO 用户名字 第五, 运行-cmd-进入dmp文件所在的...
Configure User Lists 188 Session Information 189 Change Password 190 Commit & Rollback 190 Connect and Disconnect 191 DBMS_Flashback 191 Diagnosing Problems 193 View Extents 193 Identify Space ...
Les13 : 控制用户权限[CREATE USER /GRANT / REVOKE ] Les14 : 无 Les15 : SET 运算符 Les16 : Oracle9i 日期函数 Les17 : 对 GROUP BY 子句的扩展 Les18 : 高级子查询 Les19 : Oracle9i 对 DML 和 DDL 语句的扩展 ...
core_dump_dest指定Oracle运行所产生的core dump 信息的文件的存放路径 background_dump_dest = /u02/app/oracle/admin/cams/bdump core_dump_dest = /u02/app/oracle/admin/cams/cdump user_dump_...
密码不能包含"SELECT","DELETE","CREATE"这类的Oracle/SQL 关键字。 2 Oracle 的弱算法加密机制:两个相同的用户名和密码在两台不同的Oracle 数据库机器中,将具有相同的 哈希值。这些哈希值存储在SYS.USER$表中。...