Oracle语句
一、查询语句
查看所有用户:
select username from dba_users;
查看当前连接的用户:
show user;
查看指点用户权限:
select * from dba_sys_privs where grantee = 'U_NAME';
查看当前用户权限:
select * from user_sys_privs;
查看指点用户所有表:
select * from all_tables where owner='U_NAME';
查看当前用户所有表和表空间:
select table_name,default_tablespace from user_tables;
二、创建语句
创建序列
create sequence id_seq minvalue 1 maxvalue 999999 increment by 1 start with 1;
三、修改语句
用户账号解除锁定:
alter user u_name account unlock;