skip to main
|
skip to sidebar
Oracle DBA Scripts
Oracle Production support DBA Tips
Want to post your scripts here in this blog ?
Email it to snojha@gmail.com.
You will be rewarded for your scripts if selected by our experts.
Wednesday, January 13, 2010
Check for Roles Assigned to PUBLIC
select granted_role from dba_role_privs where grantee='PUBLIC';
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Oracle DBA Scripts Links
Bijoo's Oracle DBA Scripts
DBASupport Oracle Scripts
DBCEO.com
Jeffrey M. Hunter DBA Scripts - Idev
Oracle DBA Routine Tasks
Oracle DBA Scripts with tuning Tips
ORACLE FAQ DBA Scripts
Oracle Power DBA Scripts
Oracle-Base DBA Scripts
Pro-dba Oracle Scripts
Blog Archive
▼
2010
(56)
►
August
(3)
►
July
(2)
▼
January
(51)
Oracle Critical File Protection
Oracle Redo log files
Auditing of Commands
Audit Table Permissions
Account Permissions
Resource Limits Not Enabled
REMOTE_LOGIN_PASSWORDFILE
Failed Login Attempts
Idle Time Resource Usage Limit
users or roles granted ALL PRIVILEGES or too many ...
PUBLIC is granted with Object Permissions
Roles Granted With Admin
PUBLIC is granted with System Privileges
Check which user has been granted with the 'CONNEC...
Check which user has been granted with the 'RESOUR...
Check which user has 'ALTER SESSION' and 'ALTER SY...
Prevent granting of CREATE LIBRARY
Check for privileges with 'ANY' keywordgranted.
Check for Restricted PL/SQL Packages
Check for Role Permissions
Prevent granting of privileges that have WITH GRAN...
Check Privileges Granted With Admin
SYSDBA Privilege Assignments
Check for System Privilege Assignments
Check for Roles Assigned to PUBLIC
Check for Access to System Tables/DBA Views
Check for Tablespace Quotas
Check for Default Tablespace
Replication Account Use
Oracle Predefined Roles
Check for Active Schema Owner Account
Check Developer Privileges on Shared Systems
Check for Unauthorized Object Owner
Check if DBA Includes Non-default Account
GLOBAL_NAMES Parameter
Oracle database log mode
'user_dump_dest' and 'background_dump_dest'
'user_dump_dest' and 'background_dump_dest'
Default Oracle System Identifier
Password Verify Function
Account Lock Time
Password Reuse
Password Life Time
Database Links - SQL
determine if pl/sql code is wrapped or not
Determine Version and options of database examined
Check the patch level
Get the name of the DB
Oracle Critical Patch Update Advisory - October 2009
OPatch lsinventory
How to use wrap utility to encode Oracle database ...
►
2009
(8)
►
September
(1)
►
August
(1)
►
May
(6)
►
2007
(34)
►
August
(1)
►
July
(33)
Important Links
MJB e-Services - Your Friend in the IT age
Oracle Blogs
ThinkOracle Blog
Orablogs
Oracle Blog Collections
Contributors
Blogger
MJBeservices
No comments:
Post a Comment