解锁用户

alter user setm account unlock;

删除用户

drop user setm;

修改用户密码

alter user setm identified by setm2019;

查看当前用户

show user;

执行sql文件(PATH表示文件的路径)

@PATH/filename.sql

查看当前数据库名

select name from v$database;

关闭数据库

shutdown immediate;

查询所有表

select table_name from all_tables;

测试环境授权模板

create tablespace testdb datafile ‘/data/orcl/datafile/cmisdb01.dbf’ size 5G autoextend on;
alter tablespace testdb add datafile ‘/data/orcl/datafile/cmisdb02.dbf’ size 2G autoextend on;
create user test_lmt identified by “after2019%”;
alter user test_lmt default tablespace testdb;
#alter user aftloan identified by “after2019%”;
grant connect,resource to test_lmt;
grant create view to test_lmt;
grant unlimited tablespace to test_lmt;

发表评论

邮箱地址不会被公开。