oracle数据库创建用户,创建表以及Scott的解锁
来源:互联网 发布:linux ipv6 dns设置 编辑:程序博客网 时间:2024/05/19 17:05
Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 Connected as haha@ORCLSQL> show user;User is hahaSQL> connt haha/123456;connt haha/123456ORA-00900: 无效 SQL 语句SQL> connt user haha/123456;connt user haha/123456ORA-00900: 无效 SQL 语句SQL> conn user haha/123456;SQL> SQL> conn user haha/123456;SQL> create user zz identified by 123456;create user zz identified by 123456ORA-01031: 权限不足SQL> conn system/123456;Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 Connected as systemSQL> create user zz identified by 123456;User createdSQL> conn zz/123456;SQL> show user;User is "system"SQL> conn zz/123456;SQL> grant connect,resouret to zz;grant connect,resouret to zzORA-01919: 角色 'RESOURET' 不存在SQL> grant connect,resourece to zz;grant connect,resourece to zzORA-01919: 角色 'RESOURECE' 不存在SQL> grant connect,resource to zz;Grant succeededSQL> conn zz/123456;Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 Connected as zzSQL> edSQL> SQL> create table db 2 ( 3 id number primary key, 4 d_name varchar(20) 5 ) 6 /Table createdSQL> insert into db values(10,'hhhh');1 row insertedSQL> commit;Commit completeSQL> select *from db; ID D_NAME---------- -------------------- 10 hhhhSQL> select *from db; ID D_NAME---------- -------------------- 10 hhhhSQL> select *from db; ID D_NAME---------- -------------------- 10 hhhhSQL> select *from db; ID D_NAME---------- -------------------- 11 hahhaa 10 hhhhSQL> select *from db; ID D_NAME---------- -------------------- 11 hahhaa 10 hhhh 12 vvvvvvvvvSQL> select *from db; ID D_NAME---------- -------------------- 10 hhhh 12 vvvvvvvvvSQL> select *from db; ID D_NAME---------- -------------------- 10 我爱你 12 vvvvvvvvvSQL> //解锁alter user scott account unlock;
0 0
- oracle数据库创建用户,创建表以及Scott的解锁
- Oracle创建表空间、创建用户以及授权、查看权限 、scott解锁
- Oracle数据库中Scott用户的解锁
- Oracle 中scott 用户的解锁以及修改密码
- oracle 中scott用户的创建方法
- oracle创建用户,解锁
- oracle在scott用户创建表emp
- oracle创建scott用户下表的sql语句
- oracle scott用户样本创建
- oracle 手工创建Scott用户
- Oracle 创建用户 scott 例
- oracle scott 用户解锁
- oracle解锁scott用户
- Oracle scott用户解锁
- oracle解锁scott用户
- oracle解锁scott用户
- oracle scott用户解锁
- oracle解锁scott用户
- Android 调用摄像头拍照
- 人脸对齐SDM技术
- Metrics.NET源码阅读笔记
- 8953n的user获取权限以及remount
- spring配置
- oracle数据库创建用户,创建表以及Scott的解锁
- could not load library libopencv_java.so
- android 自定义log打印
- http://www.cnblogs.com/tiantianbyconan/p/5972138.html
- Building R-devel on RedHat Linux 6
- (去重)去除数组中重复数字的算法
- 学习了一篇文章,css实现Tab
- Python扩展实现方法--Python与c混合编程
- 揭开Unity AssetBundle庐山真面目(一)