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;