今天整理user和schema相关的东东

        1.查看信息
        1.1.查看用户信息，当然有all_，user_打头的试图了，不一一列举
        select * from dba_users;

        1.2.查看用户所拥有的tablespace的配额
        select * from dba_ts_quotas;

        2.创建user/schema
        这是个经常使用的操作，这是一个连续的步骤
        2.1.创建表空间
        create tablespace test01 datafile
          '/u02/oradata/test/test01.dbf' size 500m autoextend on next 10m maxsize unlimited
        logging
        permanent
        extent management local uniform. size 1m
        blocksize 8k
        segment space management auto
        flashback on;

        2.2.创建用户
        A.语法
        这是常用的几个选项
        default tablespace一般的生产库是要求制定的，不制定可能会自动建到system，这样就很恶心了
        quota一般也是要制定的，不然会不能有操作，也很恶心
        #################################################
        #create user                                                               #
        #identified by                                                                 #
        #default tablespace                                      #
        #[temporary tablespace ]                 #
        #quota on                       #
        #[account ];                                                                #
        #################################################
        create user test identified by test123
        default tablespace test01
        quota unlimited on test01; 

        2.3.赋权
        这是最常用的权限
        grant connect,resource to test;

        3.删除user
        3.1.仅删除user，不删除objects
        drop user ;

        3.2.删除user，及连带的objects，会连带表、索引什么的一起干掉
        drop user cascade;

        4.修改user配置
        4.1.修改密码
        alter user identified by ;
        alter user account identified by values ';

        4.2.修改表空间配额
        alter user
        quota on ;

        4.3.lock/unlock单个用户
        alter user hr account lock;
        alter user hr account unlock;

        4.4.lock/unlock多个用户(通过select生成语句)
        select 'alter user ' || username || ' account lock' || ';'
          from dba_users
         where default_tablespace in ('DAXON', 'USERS', 'BACH')
           and username like 'SP0%'
         order by username;