17,377
社区成员
发帖
与我相关
我的任务
分享
SQL> conn / as sysdba;
已连接。
SQL> show parameter background_dest
SQL> show parameter background_du
NAME TYPE VALUE
------------------------------------ ----------- -----------------------------
background_dump_dest string G:\ORACLE\PRODUCT\10.1.0\ADMI
\ORCLU\BDUMP
SQL> desc role_sys_privs
名称 是否为空? 类型
----------------------------------------- -------- --------------------------
ROLE NOT NULL VARCHAR2(30)
PRIVILEGE NOT NULL VARCHAR2(40)
ADMIN_OPTION VARCHAR2(3)
SQL>select * from role_sys_privs where role=upper('connect');
ROLE PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
CONNECT CREATE VIEW NO
CONNECT CREATE TABLE NO
CONNECT ALTER SESSION NO
CONNECT CREATE CLUSTER NO
CONNECT CREATE SESSION NO
CONNECT CREATE SYNONYM NO
CONNECT CREATE SEQUENCE NO
CONNECT CREATE DATABASE LINK NO
已选择8行。
SQL> ed
已写入 file afiedt.buf
1* select * from role_sys_privs where role=upper('resource')
SQL> /
ROLE PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
RESOURCE CREATE TYPE NO
RESOURCE CREATE TABLE NO
RESOURCE CREATE CLUSTER NO
RESOURCE CREATE TRIGGER NO
RESOURCE CREATE OPERATOR NO
RESOURCE CREATE SEQUENCE NO
RESOURCE CREATE INDEXTYPE NO
RESOURCE CREATE PROCEDURE NO
已选择8行。