一:更改Oracle数据库用户命令
1,启动cmd
2,sqlplus sys/口令 as sysdba
3,alter user scott unlock;
二:分配权限
原始登录账户为scott
1,conn sys/口令 as sysdba;
2,grant create table,create view to scott;
3,conn scott/tiger
三:创建新用户
1-- backup scott
exp//cmd下
2-- create user
create user ryy identified by ryy default tablespace users quota 10M on users;//sqlplus下
grant create session,create table,create view to ryy;//分配权限,sqlplus下
3-- import the data
imp//cmd下
四:数据备份
create table emp2 as select * from emp;
五:撤销命令
1,启动cmd
2,sqlplus sys/口令 as sysdba
3,alter user scott unlock;
二:分配权限
原始登录账户为scott
1,conn sys/口令 as sysdba;
2,grant create table,create view to scott;
3,conn scott/tiger
三:创建新用户
1-- backup scott
exp//cmd下
2-- create user
create user ryy identified by ryy default tablespace users quota 10M on users;//sqlplus下
grant create session,create table,create view to ryy;//分配权限,sqlplus下
3-- import the data
imp//cmd下
四:数据备份
create table emp2 as select * from emp;
五:撤销命令
rollback;//撤销上一步操作命令
六:提交命令
commit;