Problem Description ——————- The DBA needs to know which values are assigned to limits set to DEFAULT for a given profile. Querying DBA_PROFILES does not display the actual values but rather lists DEFAULT for those LIMITs. Solution Description ——————– From the SQL*Plus prompt, type: SQL> select * from dba_profiles where profile = ‘DEFAULT’; PROFILE RESOURCE_NAME…
The REFERENCES object privilege allows a user to describe a table for which he has been granted the privilege on.
Normal triggering events doesn’t succeed when corresponding triggers fails. But there is EXCEPTION for STARTUP events: STARTUP events succeed even if the trigger fails. There are also exceptions for SHUTDOWN events and for LOGON events if you login as SYSTEM
Advanced Security Options. On a UNIX platform run the ‘adapters’ command at the shell. If you have ASO installed you will see something like, Installed Oracle Advanced Security option/Security products are: RC4 40-bit encryption algorithm RC4 56-bit encryption algorithm DES40 40-bit encryption algorithm DES 56-bit encryption algorithm MD5 crypto-checksumming algorithm On Windows you will need…
Help In this Document Purpose Scope and Application All About Security: User, Privilege, Role, SYSDBA, O/S Authentication, Audit, Encryption, OLS, Database Vault, Audit Vault 1) Alerts 2) System Privileges 3) Object Privileges 4) Users and Roles 5) User and Tablespace Quotas 6) Profiles and Resource Limits 7) Password Management 8) Connect Internal and Password Files…
Read More “All About oracle password and security from metalink” »
fix: 1) Log on as SYSDBA 2) Create database link between source and target database 3) Create procedure which selects usernames,passwords from DBA_USERS in source database and inserts usernames,passwords into target database Sample SQL-statements source database: SQL> select password from dba_users where username=’SCOTT’; USERNAME PASSWORD —————————— —————— SCOTT F894844C34402B67 target database: Sqlplus> Create user SCOTT…
Read More “How To Transfer Passwords Between Databases (ref note: 199582.1)” »
find the runnung process’s environment
Goal After a process has been started, in order to find out the environment that was used to start it, the following methods can be used, depending on the OS platform: Solution 1. Determine the pid of the process at OS level, eg for the smon process: ps -ef | grep smon 2. Get the…
Read More “Which environment is used by currently running process ( Very good)” »
Recovering from lost sys password using OS authentication on Unix. #1. make sure that the OS user that is logged on is member of the dba group. If the dba group is not known, check the file: $ORACLE_HOME/rdbms/lib/config.c (or config.s) #2. make sure that the sqlnet.ora file does not contain the: sqlnet.authentication_services parameter. If this…
Following command will be used for Tarring/copying local files and untarring/extracting at target folder. $ tar cf – * | ( cd /target; tar xfp -)
