oracle 基本操作
--创建临时表空间CREATE TEMPORARYTABLESPACE A01_temp
TEMPFILE'D:\oracle\product\10.2.0\oradata\lhl\DB\A01_temp.dbf '
SIZE 32M
AUTOEXTENDON
NEXT32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;
--创建用户表空间
CREATETABLESPACE A01_data
LOGGING
DATAFILE'D:\oracle\product\10.2.0\oradata\lhl\DB\A01_data.DBF '
SIZE 32M
AUTOEXTENDON
NEXT32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;
--创建用户并制定表空间
CREATE USERA01 IDENTIFIEDBY"1"
DEFAULTTABLESPACE A01_data
TEMPORARYTABLESPACE A01_temp;
--给用户授予(角色)权限CONNECT,resource,DBA
GRANT CONNECT,resource TO A01;
drop USERA01
-----------------------------------------------查看用户权限---------------------------------------------------------
查看所有用户
SELECT * FROMDBA_USERS;
SELECT * FROMALL_USERS;
SELECT * FROMUSER_USERS;
查看用户系统权限
SELECT * FROMDBA_SYS_PRIVS;
SELECT * FROMUSER_SYS_PRIVS;
查看用户对象或角色权限
SELECT * FROMDBA_TAB_PRIVS;
SELECT * FROMALL_TAB_PRIVS;
SELECT * FROMUSER_TAB_PRIVS;
查看所有角色
SELECT * FROMDBA_ROLES;
查看用户或角色所拥有的角色
SELECT * FROMDBA_ROLE_PRIVS;
SELECT * FROMUSER_ROLE_PRIVS;
页:
[1]