Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\AEUTL\sql_utl_sec.htm
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=us-ascii" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <meta http-equiv="Content-Script-Type" content="text/javascript" /> <title>Security Reports</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1" /> <meta name="date" content="2009-04-14T18:10:1Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Security Reports" /> <meta name="relnum" content="Release 3.2" /> <meta name="partnum" content="E12511-01" /> <link rel="copyright" href="../dcommon/html/cpyr.htm" title="Copyright" type="text/html" /> <link rel="stylesheet" href="../dcommon/css/blafdoc.css" title="Oracle BLAFDoc" type="text/css" /> <link rel="contents" href="toc.htm" title="Contents" type="text/html" /> <link rel="up" href="preface" title="Home" type="text/html" /> <link rel="up" href="sql_utl.htm" title="Using Oracle Application Ex..." type="text/html" /> <link rel="up" href="sql_utl_obj_rpt.htm" title="Viewing Object Reports" type="text/html" /> <link rel="up" href="sql_utl_sec.htm" title="Security Reports" type="text/html" /> <link rel="prev" href="sql_utl_tbl.htm" title="Previous" type="text/html" /> <link rel="next" href="sql_utl_plsql.htm" title="Next" type="text/html" /> </head> <body> <p id="BREADCRUMBING"><a href="preface" title="Home">Home</a> > <a href="sql_utl.htm" title="Using Oracle Application Ex...">Using Oracle Application Ex...</a> > <a href="sql_utl_obj_rpt.htm" title="Viewing Object Reports">Viewing Object Reports</a> > Security Reports</p> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr valign="bottom"> <td align="left"></td> <td align="center"><a href="sql_utl_tbl.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="sql_utl_plsql.htm"><img src="../dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BABHBCIH" name="BABHBCIH"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1><a name="AEUTL259" id="AEUTL259"></a>Security Reports</h1> <p>Use the Security reports to view object or column privileges granted on database objects owned by other schemas. You can also use these reports to view database role and system privileges.</p> <p>To view the Security reports:</p> <ol> <li> <p>On the Workspace home page, click the <span class="bold">Utilities</span> icon.</p> </li> <li> <p>Click <span class="bold">Object Reports</span>.</p> <p>The Object Reports page appears.</p> </li> <li> <p>In the Security Reports section, click the report you want to view:</p> <ul> <li> <p><span class="bold">Object Grants</span> - View the privileges for an existing schema and also understand what privileges have been granted from the selected schema to other schemas.</p> </li> <li> <p><span class="bold">Column <a id="sthref293" name="sthref293"></a><a id="sthref294" name="sthref294"></a><a id="sthref295" name="sthref295"></a>Privileges</span> - View the privileges for an existing schema and also understand what privileges have been granted from the selected schema to other schemas.</p> </li> <li> <p><span class="bold">Role <a id="sthref296" name="sthref296"></a><a id="sthref297" name="sthref297"></a>Privileges</span> - View the database roles that have been granted to a selected schema. Roles are collections of various privileges.</p> </li> <li> <p><span class="bold">System <a id="sthref298" name="sthref298"></a><a id="sthref299" name="sthref299"></a>Privileges</span> - View the database privileges that have been granted to a selected schema.</p> </li> </ul> </li> <li> <p>If available, you can filter the report by making a selection from the Show list and clicking <span class="bold">Go</span>.</p> </li> <li> <p>To view reports for a different schema, select the schema from the Schema list on the upper right side of the page.</p> </li> </ol> </div> <!-- class="sect2" --> <!-- Start Footer --> <div class="footer"> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr> <td align="left"><span class="copyrightlogo">Copyright © 2003, 2009, Oracle and/or its affiliates. All rights reserved.</span><br /> <a href="../dcommon/html/cpyr.htm"><span class="copyrightlogo">Legal Notices</span></a></td> <td align="center"><a href="sql_utl_tbl.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="sql_utl_plsql.htm"><img src="../dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> </div> <!-- class="footer" --> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de