2 Shares 1 Share Facebook 1 Share Twitter 1K Share LinkedIn 1K Share Facebook Messenger 1K Share WhatsApp 1K Share Email The Database Security Assessment Tool (DBSAT) is an incredible free command line tool provided by Oracle Corporation as a utility to help you verify your database for common database security issues(including security policies and controls in…
Category: Security
Playing with Google Authenticator and Oracle Cloud – Securing SSH to Oracle account with two factor authentication
0 Shares 1K Share Facebook 1K Share Twitter 1K Share LinkedIn 1K Share Facebook Messenger 1K Share WhatsApp 1K Share Email The Requirement Increase security when connecting via SSH to the Oracle OS account at Oracle Cloud by implementing two factor authentication (TFA or 2FA). The Environment Oracle Cloud Instance OS: Oracle Linux 6.9 The…
Oracle CPU (Critical Patch Update) January-2009
0 Shares 1K Share Facebook 1K Share Twitter 1K Share LinkedIn 1K Share Facebook Messenger 1K Share WhatsApp 1K Share Email The first CPU of 2009 is already out, was released on January 13, 2009. Like always, Oracle strongly recommends applying the patches as soon as possible. To know more about the January CPU like…
How to find all user Roles and Privileges?
0 Shares 1K Share Facebook 1K Share Twitter 1K Share LinkedIn 1K Share Facebook Messenger 1K Share WhatsApp 1K Share Email Here is the scripts to help you to get this information: PROMPT PROMPT PROMPT ******************************************** ROLES AND PRIVILEGES PROMPT PROMPT ******************************************** USER ROLES SELECT grantee user, granted_role, admin_option, default_role FROM dba_role_privs WHERE grantee IN…
How to setup a Basic Audit?
0 Shares 1K Share Facebook 1K Share Twitter 1K Share LinkedIn 1K Share Facebook Messenger 1K Share WhatsApp 1K Share Email For any Oracle versions prior to 9i you will need to set audit_trail parameter in the pfile ie.g.: audit_trail = DB For later Oracle Versions: SQL>alter system set audit_trail = DB; To enable auditing…