oracle命令笔记

1.远程登入数据库。
sqlplus sys/oracle@VMorcl as sysdba
如果不是远程则不需要@VMORCL,此是数据库客户端的实例
2. 创建用户以及分配表空间
create user snpm identified by snpm default tablespace users;
3. 授权
grant connect,resource to snpm;
4. 查找当前有哪些用户
select * from all_users;
5. 更改权能，解锁
alter user SCOTT account unlock;
alter user scott identified by tiger;
grant connect,resource to scott;
grant create view to scott;