关于ORACLE辅助语句

--JOBS
DECLARE
X NUMBER;
BEGIN
SYS.DBMS_JOB.SUBMIT(job => X,
what => 'sp_test();',
next_date => to_date('28-04-2009 11:58:00',
'dd/mm/yyyy hh24:mi:ss'),
interval => 'SYSDATE+1');
END;
/
commit;
select to_char(sysdate-90,'yyyymmdd') from dual;  --选择日期
select * from dba_jobs;--查看作业
CREATE USER SLCARD  PROFILE DEFAULT
    IDENTIFIED BY slcard DEFAULT TABLESPACE USERS
    ACCOUNT UNLOCK;
GRANT CONNECT TO SLCARD;
GRANT DBA TO SLCARD;
GRANT RESOURCE TO SLCARD;
--REVOKE DBA,CONNECT,RESOURCE from SLCARD;
1.查看所有用户：
  select * from dba_users;
  select * from all_users;
  select * from user_users;
2.查看用户或角色系统权限：
  select * from dba_sys_privs;
  select * from user_sys_privs;
3.查看用户对象权限：
  select * from dba_tab_privs;
  select * from all_tab_privs;
  select * from user_tab_privs;
4.查看所有角色：
  select * from dba_roles;
5.查看用户或角色所拥有的角色：
  select * from dba_role_privs;
  select * from user_role_privs;
6.查看连接数
select username,count(username) from v$session where username is not null group by username
-- 确定角色的权限
select * from role_tab_privs ;  数据字典视图包含了授予角色的对象权限
select * from role_role_privs ;             包含了授予另一角色的角色
select * from role_sys_privs ;              包含了授予角色的系统权限
-- 确定用户帐户所授予的权限
select * from DBA_tab_privs ;   直接授予用户帐户的对象权限
select * from DBA_role_privs ;  授予用户帐户的角色
select * from DBA_sys_privs ;   授予用户帐户的系统权限
查看当前用户权限:
select * from session_privs;、
--更改临时表空间
ALTER database TEMPFILE 'I:\oracle\oradata\sldev\temp02.dbf' reSIZE 300M;
ALTER TABLESPACE TEMP ADD TEMPFILE 'I:\oracle\oradata\sldev\temp02.db