Scripts:列出角色信息的脚本sec_roles.sql
来源:互联网 发布:钢结构棚子算法 编辑:程序博客网 时间:2024/06/05 20:44
-- +----------------------------------------------------------------------------+
-- | Jeffrey M. Hunter |
-- | jhunter@idevelopment.info |
-- | www.idevelopment.info |
-- |----------------------------------------------------------------------------|
-- | Copyright (c) 1998-2012 Jeffrey M. Hunter. All rights reserved. |
-- |----------------------------------------------------------------------------|
-- | DATABASE : Oracle |
-- | FILE : sec_roles.sql |
-- | CLASS : Security |
-- | PURPOSE : Report on all roles defined in the database and which users |
-- | are assigned to that role. |
-- | NOTE : As with any code, ensure to test this script in a development |
-- | environment before attempting to run it in production. |
-- +----------------------------------------------------------------------------+
SET TERMOUT OFF;
COLUMN current_instance NEW_VALUE current_instance NOPRINT;
SELECT rpad(instance_name, 17) current_instance FROM v$instance;
SET TERMOUT ON;
PROMPT
PROMPT +------------------------------------------------------------------------+
PROMPT | Report : Security - All Roles |
PROMPT | Instance : ¤t_instance |
PROMPT +------------------------------------------------------------------------+
SET ECHO OFF
SET FEEDBACK 6
SET HEADING ON
SET LINESIZE 180
SET PAGESIZE 50000
SET TERMOUT ON
SET TIMING OFF
SET TRIMOUT ON
SET TRIMSPOOL ON
SET VERIFY OFF
CLEAR COLUMNS
CLEAR BREAKS
CLEAR COMPUTES
COLUMN role FORMAT a30 HEAD 'Role Name'
COLUMN grantee FORMAT a30 HEAD 'Grantee'
COLUMN admin_option FORMAT a15 HEAD 'Admin Option?'
COLUMN default_role FORMAT a15 HEAD 'Default Role?'
BREAK ON role SKIP 2
SELECT
b.role
, a.grantee
, a.admin_option
, a.default_role
FROM
dba_role_privs a
, dba_roles b
WHERE
granted_role(+) = b.role
ORDER BY
b.role
, a.grantee
/
-- | Jeffrey M. Hunter |
-- | jhunter@idevelopment.info |
-- | www.idevelopment.info |
-- |----------------------------------------------------------------------------|
-- | Copyright (c) 1998-2012 Jeffrey M. Hunter. All rights reserved. |
-- |----------------------------------------------------------------------------|
-- | DATABASE : Oracle |
-- | FILE : sec_roles.sql |
-- | CLASS : Security |
-- | PURPOSE : Report on all roles defined in the database and which users |
-- | are assigned to that role. |
-- | NOTE : As with any code, ensure to test this script in a development |
-- | environment before attempting to run it in production. |
-- +----------------------------------------------------------------------------+
SET TERMOUT OFF;
COLUMN current_instance NEW_VALUE current_instance NOPRINT;
SELECT rpad(instance_name, 17) current_instance FROM v$instance;
SET TERMOUT ON;
PROMPT
PROMPT +------------------------------------------------------------------------+
PROMPT | Report : Security - All Roles |
PROMPT | Instance : ¤t_instance |
PROMPT +------------------------------------------------------------------------+
SET ECHO OFF
SET FEEDBACK 6
SET HEADING ON
SET LINESIZE 180
SET PAGESIZE 50000
SET TERMOUT ON
SET TIMING OFF
SET TRIMOUT ON
SET TRIMSPOOL ON
SET VERIFY OFF
CLEAR COLUMNS
CLEAR BREAKS
CLEAR COMPUTES
COLUMN role FORMAT a30 HEAD 'Role Name'
COLUMN grantee FORMAT a30 HEAD 'Grantee'
COLUMN admin_option FORMAT a15 HEAD 'Admin Option?'
COLUMN default_role FORMAT a15 HEAD 'Default Role?'
BREAK ON role SKIP 2
SELECT
b.role
, a.grantee
, a.admin_option
, a.default_role
FROM
dba_role_privs a
, dba_roles b
WHERE
granted_role(+) = b.role
ORDER BY
b.role
, a.grantee
/
0 0
- Scripts:列出角色信息的脚本sec_roles.sql
- Scripts:列出用户信息的脚本sec_users.sql
- Scripts:诊断DRM信息的脚本DRMDIAG.SQL
- Scripts:查询参数信息的脚本parms.sql
- Scripts:查询所有参数修改信息的脚本parm_mods.sql
- Scripts:查询回滚段信息的脚本rollback_segments.sql
- Scripts:报告所有用户session信息的脚本sess_user_sessions.sql
- Scripts:根据sql文本找出相应SQL信息的脚本find_sql.sql
- 用户admin所属角色组的id是固定的,用一条sql列出admin所有的角色信息
- Scripts:列出所有连接数据库的用户信息sess_users.sql
- Scripts:根据sid,ospid来查询进程信息的脚本os_pid.sql
- 列出 sql server某个数据库的角色 及 表名
- Scripts:重建索引的脚本(看懂脚本再用)rebuild_indx.sql
- Scripts:查看回滚的SQL的脚本 huigun.sql
- Scripts:生成随机数的SQL脚本dba_random_number.sql
- Scripts:查询等待事件的SQL脚本owi_event_names.sql
- Scripts:给出系统pid找出sql的脚本pid4sql.sql
- Scripts:按日期查询归档信息的SQL check_archive.sql
- OBIEE11g Important Application/Services and directory paths
- Scripts:列出用户信息的脚本sec_users.sql
- Deep Learning源代码收集-持续更新…
- 热键注册
- 配置SQL Server 2008 数据源(ODBC编程)
- Scripts:列出角色信息的脚本sec_roles.sql
- OpenGL ES入门详解
- unityvs每次都要输入license问题
- 【Linux驱动】文件描述符以及相关知识
- 《构建跨平台APP:jQuery Mobile移动应用实战》
- 一个Java程序员应该掌握的10项技能
- Scripts:列出所有连接数据库的用户信息sess_users.sql
- OpenCV下HSV分量的值
- 安装JDK出现"Windows Installer程序包有问题,此安装需要的DLL不能运行"解决方法